Database is the heart of any website, blog, etc. It should be handled with delicate care. To repair a MySQL Database, follow the instructions below:
Procedure:
1. On the homepage of your cPanel, click the MySQL Databases icon under Databases.
2. Under the Modify Databases, select the database you want to check from the drop down menu.
3. When you are done, click the Repair DB button.
4. cPanel will run a script to repair and restore the database into working condition so that it will be fully functional again. If cPanel cannot repair it, it will let you know.