How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?

Your databases’ tables and indexes may occasionally get destroyed or corrupted, in which case you would need to rebuild them. Making repairs to the database is a straightforward solution.

Repair MySQL Database

via cPanel

via WHM

via phpMyAdmin

To Repair MySQL Database via cPanel

1. Log in to your cPanel account.

2. Go to the DATABASES section and click on MySQL® Databases.

3. Find the Modify Databases section and

• select the database from the drop-down list of the Repair Database field.
• Click on the Repair Database button.

The cPanel will display the message: Repair Complete!

To Repair MySQL Database via WHM

1. Log in to the WHM panel with your root account.

2. Select the SQL Services in the navigation menu.

3. Click on Repair a MySQL Database.

A list of databases will appear.

4. Select the database you want to repair from the list and click the Repair Database button.

It will take a while for the system to complete the process, depending on the database. After repairing the database, the system will show a success message:

To Repair MySQL Database via phpMyAdmin

Users can access phpMyAdmin via cPanel and WHM interfaces.

To Open phpMyAdmin from cPanel

1. Log in to your cPanel account.

2. Scroll to the DATABASES section and click on phpMyAdmin.

To Open phpMyAdmin from WHM

1. Log in to the WHM panel with your root account.

2. Select the SQL Services in the navigation menu.

3. Click on phpMyAdmin.

Once you have opened the phpMyAdmin module, you can follow these steps to repair a database.

1. Click the Databases tab and select a database from the list.

A list of tables of the database will appear.

2. Tick the Check all box to select all tables of the database.

There is a field with a list box beside it saying- With selected:

3. Open the list and click the Repair table option.

The phpMyAdmin will execute the query for the database tables. After some time, a success message along with a brief report will appear indicating the database tables have been repaired.

Warning: In some cases, repair operation on a database may cause data loss. As a precaution, we recommend you take a backup of the database before performing a repair operation.

How To Install & Configure PostgreSQL?