How to repair a corrupted MySQL database from cPanel and phpMyAdmin
Sometimes, your MySQL database may be corrupted and it requires to repair your MySQL database. Here we will provide you steps to repair corrupted MySQL database from cPanel and phpMyAdmin.
[1] Repair a MySQL database from cPanel
Log in to your cPanel and go to MySQL Databases. In the section Modify Databases, select a database from the drop-down box next to Repair DB: and then click the Repair DB button.
If the database engine used by your database supports repair (for example, MyISAM supports it), you will see a list of the repaired tables within the database.
If your database engine does not support repair (e.g. InnoDB database engine), you will get the following error message:
note : The storage engine for the table doesn’t support repair
[2] Repair a MySQL database from phpMyAdmin
- Open your phpMyAdmin and select the database whose tables you wish to repair.
- Select the tables you wish to repair, or simply click [Check All] to select all tables.
- Click the box [With selected:] and choose Repair table. This will execute the REPAIR TABLE SQL query on the selected tables and they will be repaired.
Related Posts
- How to optimize MySQL database using phpMyAdmin
- How to change MySQL database collation from phpMyAdmin in cPanel
- How to change the database storage engine of a MySQL database table
- How to create a MySQL database from cPanel
- How to reset Joomla administrator password
Comments
Leave a Reply
You must be logged in to post a comment.
-
Recommended Host
-
