How to Repair and Optimize a MySQL Database

Here are the steps to repair and/or optimize a MySQL database.

1. Log in to your Account Manager.
2. Click the Hosting tab on the left-hand menu.

   

3. Search for the hosting plan where your database is, and then click its Manage button.

   

4. Click MySQL Management in the left-hand menu.

   

5. Locate the database you need to manage, then click its Manage link on the right.

   

6. Look for your database username and click the phpMyAdmin link next to it.

   

7. You will be redirected to phpMyAdmin. Click on the database name on the left.
8. You'll see a list of your database tables on the right pane. At the bottom of the page, click Check all.

   

9. Select Repair Table from the drop-down menu.

   

10. To optimize the database, repeat steps 7 and 8, then select the Optimize table option in the drop-down menu.