MySQL Repair / Optimize Tables in phpMyAdmin

Problem:

How to repair and optimize databases using phpMyAdmin:

Solution:

Occasionally the MySQL database may run slower than desired. This issue can be fixed quickly through phpMyAdmin.

(Note: Please back up any database on the account before making changes)

  1. Log into cPanel.
  2. Click on phpMyAdmin.
  3. On the left will be a list of databases. Select the one to repair/optimize.
  4. This will load all of the tables in your database into the right side. At the bottom of this list, check the "Check All" checkbox.
  5. Just to the right of the Check All link, select the "Repair" option in the drop-down list.
  6. This will list all the tables, with "OK" listed next to them. When this is done, look up to the top of the page and click on the "Structure" tab.
  7. Once the process has finished the page will revert back to step 4.
  8. Click "Check All" again, and then choose "Optimize" in the drop down menu.
Now the process is done!

Many MySQL errors can be fixed by this process. It is recommended to perform these steps frequently to keep any database in good condition.

  • 24 Users Found This Useful
Was this answer helpful?

Related Articles

MySQL Database Creation

Problem: How do I create an empty MySQL Database? Solution: Databases offer a method for...

Remote Database Connection Setup

How do I remotely connect using a database management software? Databases in cPanel can be...

MySQL Import and Export (.sql file) via SSH

Problem: How to import and export a MySQL Database from the command line. Solution: MySQL...

MySQL Import and Export (.sql file) via PhpMyAdmin

Problem: I need to Export or Import a MySQL database Solution: Note: PhpMyAdmin can only...

Connecting to your MySQL DB from Dream Weaver

Problem: How can I connect to our MySQL database from Dream Weaver? Solution: Log into your...