Home Support Center Our Products Premium Hosting How do I optimize my MySQL database in PhpMyAdmin?

How do I optimize my MySQL database in PhpMyAdmin?

Optimizing your database tables regularly will improve your website's performance. Here's how to optimize your MySQL database using the PhpMyAdmin tool in Premium Hosting:

  1. Log on to your Affilorama account at http://www.affilorama.com. The login form is located on the upper right corner of the home page
  2. Once logged in, you will see a list of your Affilorama products and bonuses on the upper right side of the page. Select Premium Hosting from this list.
  3. Log on to the Premium Hosting control panel by clicking on the Access button right next to the domain name you wish to manage.
  4. Once logged in, click the MySQL Databases link under the Web Tools section of the control panel.
  5. Locate the database from the Manage MySQL Databases section. Click the Manage button for the database that you want to optimize. This will launch the PhpMyAdmin tool on a separate tab or window.
  6. In PhpMyAdmin, select the database on the left pane. This will load the database tables on the right pane of the PhpMyAdmin page.
  7. Select all the tables on the right pane by clicking the Check All link below the tables list.
  8. Select the Optimize option from the With Selected drop down menu at the bottom of the tables list. DO NOT select DROP or EMPTY . Doing this will wipe out the entire database.
  9. Repeat the process until all the tables are up to date.


Related Questions

Need more help? Email us your question.

Support Center Home
Call Support
(877) 393-5850
Online: Mon-Fri 5:00pm til 1:00am EST
Email Us
We'll do our best to get back to you within 24 hours.
Ask Affilorama Members
Converse with the Affilorama team and other Affilorama users

Service status

Service is operating normally

Article Short URL