Home | Troubleshooting |  Quick Setup  |  Cisco How to  |  Data Recovery  |  Forums   | Blog | IT Exam Practice | Services  | About Us | Chicagotech MVP  | Search  | Contact Us  |               Select a Topic VPN How To Network How To Remote Access How To Windows How To Internet How To New Topics   

How to repair and optimize MySQL database using phpMyAdmin

If your MySQL database is runing slower or comes up with errors, you may be able to fix these issues by repairing it using phpMyAdmin.

1. Log into your cpanel.
2. Click on phpMyAdmin.
3. On the left will be a list of your databases. Select the one you want to repair/optimize.
4. This will load all of the tables in your database into the right side. At the bottom of this list, there is a link called "Check All". Click that.
5. Just to the right of the check all link there is a drop down menu that says "With Selected." Click on that, and choose "repair".
6. You should get a page that 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.

Post your questions, comments, feedbacks and suggestions

Contact a consultant

Related Topics