Chat with us, powered by LiveChat
Steps to Repair MySQL Database

Steps to Repair MySQL Database

To Repair a MySQL database,  one must follow these steps  :

Step 1 : First login to cPanel and click on Mysql Databases

Step 2 : Once page is loaded there are two ways to repair a database

Step 2.1 : First way is where it says Databases it says

Repair click on that button and it should load a new page with everything saying OK. This mean database is repaired

Step 2.2 : The other way is when the page loads scroll to the bottom and click on PhpMyAdmin

Step 3 : Once PhpMyAdmin has loaded select the database from the drop down menu on the left

Step 4 : Choose the database to repair and once its loaded, you can select the tables to repair, either one or them all then the dropdown that says with selected:

Step 5 : Choose Repair Table

And a new page will load saying ok.

Once this is done your tables will be repaired.

If you wish to use ssh then just execute following commands :

mysqlcheck -B databasename –auto-repair

To repair all databases

mysqlcheck -A –auto-repair

For more information about our managed web hosting services, visit our homepage.

Sharing

Leave your comment

Pin It on Pinterest

Share This