Watch this video for a step by step process on How to Repair MySQL Database via cPanel, WHM and phpMyAdmin
Although rare, the tables and indexes of your databases can get damaged or corrupted, which means you need to rebuild them. A simple way to fix it is by repairing the database.
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.
