Knowledgebase
How to repair and optimize MySQL databases using phpMyAdmin
In this article we will show you how to repair and optimize your databases using phpMyAdmin.
You can access phpMyAdmin from the Databases section of the Pixie control panel. There's a link on the right side of the screen.
In phpMyAdmin click on the name of the database you want to repair/optimize in the left frame to view its tables in the right frame.
To repair database tables mark the checkboxes in front of the tables, or click on Check All at the bottom, then select Repair table from the With selected drop-down menu at the bottom of the page and click on the Go button in the lower right corner.
To optimize the database, after you mark the checkboxes for the tables select Optimize table from the With selected drop-down menu and click on the Go button.
For some more details and screenshots you can also check out the tutorial on repairing and optimizing MySQL databases.