Knowledge Base

How to optimize and repair MySQL databases using phpMyAdmin

This article describes how to optimize and repair MySQL databases using phpMyAdmin.

Optimizing MySQL databases

Databases have the potential to grow very large, particularly on sites that receive a lot of traffic or have a large amount of content. In such cases, periodic database optimization may help improve web site performance.

To optimize a MySQL database, follow these steps:

  1. Log in to cPanel.
    If you do not know how to log in to your cPanel account, please see this article.
  2. In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.
  3. In the left pane, click the name of the database that you want to optimize. For example, the following image shows the example_wordpress database selected:

    phpMyAdmin - left pane

  4. In the right pane, select the check boxes for the tables in the database that you want to optimize.

    To select all of the tables at once, select the Check All check box.

    phpMyAdmin - main pane

  5. In the With selected list box, select Optimize table. phpMyAdmin informs you whether or not the optimization process is successful.

Repairing MySQL databases

Databases can become corrupted for any number of reasons, from software defects to hardware issues. If this occurs, you can try to repair database tables using phpMyAdmin.

To repair MySQL database tables, follow these steps:

  1. Log in to cPanel.
    If you do not know how to log in to your cPanel account, please see this article.
  2. In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.
  3. In the left pane, click the name of the database that you want to work on. For example, the following image shows the example_wordpress database selected:

    phpMyAdmin - left pane

  4. In the right pane, select the check boxes for the tables in the database that you want to repair.

    To select all of the tables at once, select the Check All check box.

    phpMyAdmin - main pane

  5. In the With selected list box, select Repair table. phpMyAdmin informs you whether or not the repair process is successful.

More Information

For more information about phpMyAdmin, please visit http://www.phpmyadmin.net.