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.
  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:

    Inspedium Web Hosting - Database View in PHPMyAdmin

  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.

      Inspedium Web Hosting - Database View in PHPMyAdmin

  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.
  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:

    Inspedium Web Hosting - Database View in PHPMyAdmin

  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.

      Inspedium Web Hosting - Database View in PHPMyAdmin

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


 

  • MySQL, phpmyadmin, Repair MySQL Database, Optimize MySQL Database
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Becoming Familiar with Databases in phpMyAdmin

We are going to assume that you are logged in to phpMyAdmin.The main screen is divided into two...

How to Manage MySQL Databases and Users in cPanel

This article describes how to use cPanel to manage MySQL databases and users. You can add,...

How to Access phpMyAdmin in cPanel

This article describes the third-party SQL management tool phpMyAdmin. This web-based database...

How to Configure Remote MySQL Access in CPanel

This article describes how to use cPanel to allow external hosts to access your MySQL databases....

How to Use PHPMyAdmin to Copy a MySQL Database

This article describes how to copy a MySQL database using phpMyAdmin. Copying a MySQL Database...

Powered by WHMCompleteSolution