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
  • 38 Users Found This Useful
Was this answer helpful?

Related Articles

What is the version of MySQL

The installed version of MySQL on all shared web hosting, VPS hosting and dedicated servers is...

How to assign a user to a MySQL database in cPanel

How to assign a user to a MySQL database in cPanel? First you need to log in to the cPanel...

How to repair a MySQL database in cPanel

How to repair a MySQL database in cPanel? In order to repair a MySQL database in cPanel, you...

How to check a MySQL database for errors in cPanel

How to check a MySQL database for errors in cPanel? First of all log in to the cPanel by using...

How to Change a MySQL Database Users Password in cPanel

How to Change a MySQL Database Users Password in cPanel? First you should log in to the cPanel...