Optimization and repair of MySQL database

If you have suspicions that the MySQL database is running slowly or appear errors, you need to optimize and/or repair the database. This can be done through your control panel cPanel ---> phpMyAdmin

Steps to optimize and repair MySQL database:

  1. Log into your web hosting control panel cPanel
  2. Select the button phpMyAdmin
  3. After login to phpMyAdmin, on the left you’ll see the list of established databases. Click the one you want to optimize or repair
  4. After selecting the database you’ll see all the tables on the right side. Select the “Check all” link and mark all tables
  5. From the drop-down menu select the Optimize table/Repair table
  6. Then the page should be loaded in the list of all tables and have the status OK
  • 53 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL from my computer

Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...

Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you receive this error message when connecting to MySQL trough command line on your VPS...

Export and import of MySQL databases from cPanel

For management on databases in your hosting account you can use the web application phpMyAdmin....

Export and import MySQL databases via SSH

If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...

How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...