How to repair a MySQL database?
Author: admin admin Reference Number: AA-00335 Views: 4214 Created: 2013-04-11 13:03 Last Updated: 2013-04-11 13:03 0 Rating/ Voters

In this article we will show you two ways to repair a MySQL database.

    1) Through 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

1
   
 

    2) Through phpMyAdmin:

Open your phpMyAdmin tool and select the database whose tables you wish to repair.

A list with all the database’s tables will appear. Tick 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.n and re-install your application with it.

Quick Jump Menu