How to repair and optimize your database using phpMyAdmin:

Sometimes the MySQL database may run slower than you would like or could come up with errors. Many of these issues can be fixed very quickly through phpMyAdmin.

Just follow these steps: (Note: It is always a good idea to back up your database before making any changes)

  1. Log into your cpanel.
  2. Click on phpMyAdmin.
  3. On the left will be a list of your 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. This will take you back to the page you saw on step 4.
  8. Click "Check All" again, and then choose "Optimize" in the drop down menu.
You should see the same page as in step 6. You're done!

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

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What version of MySQL are you running?

The current version can be viewed in the cPanel on left side.

I can't connect to my database locally or remotely, do I have the correct server, username and password?

Since we run a shared hosting environment, we have to uniquely identify your MySQL Users to your...

How do I create an empty MySQL Database

To create the database, do the following: Log into the cpanel Click the MySQL Databases icon...

How do I create a MySQL backup?

There are three options available to backup your MySQL databases: 1) Use the backup utility in...