How do I optimize or repair a MySQL database? Print

If your site is slow or a table looks corrupted, optimize or repair it in phpMyAdmin:

1. Open phpMyAdmin from cPanel and select your database.
2. On the table list, tick the boxes for the affected tables (or click Check all).
3. From the With selected dropdown at the bottom, choose Repair table to fix corruption, or Optimize table to reclaim space and improve speed.

cPanel also offers MySQL Databases > Repair Database for a one-click repair. Take an Export backup first. If a table will not repair, open a ticket and we can run deeper recovery from the server side.