1.Login into 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 Repaire a MYSQL Database via WHM
1.Login into WHM
2.Search Tools and Account Section
3.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.Login into WHM
2.Search Tools and Accounts >>Search >>phpMyAdmin
Once you have opened the phpMyAdmin module, you can follow these steps to repair a database.
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.
