View source

<div align=justify>In some cases you will need tooptimize your database to reduce the number of resources used in order to prevent server high-load. In this article we'll let you know how exactly this can be done. 
There are two ways to repair a MySQL database. 

* '''Via cPanel: '''

Log in to your '''cPanel => MySQL Databases'''. From the '''Modify Databases''' section, select a database from the drop-down box next to '''Repair DB:'''  and click the '''Repair DB''' button.

 {{#icon: Repair DB.png|Repair database}}

In case the database engine your database uses supports repair, you will be presented with a list of the repaired tables within the database.

If repairing feature is not supported by your database engine (e.g. InnoDB database engine), the following error message will appear:

 ''Note : The storage engine for the table doesn't support repair''


* '''Via phpMyAdmin: '''

'''1.''' Open phpMyAdmin and select the database you want to repair.

 {{#icon: phpMyAdmin.png|phpMyAdmin}}

'''2.''' From the list of the database's tables tick the tables you wish to repair. Alternatively you can simply click '''[Check All]''' to select all tables. 

'''3.''' Click the box [With selected:] and choose '''Repair table'''. 

 {{#icon: manage MySQL database.png|phpMyAdmin}}

 {{#icon: phpMyAdmin tool.png|phpMyAdmin}}</div>

Return to How to repair a database.

Retrieved from "http://myidealhost.com/tutorials/How_to_repair_a_database"

Navigation

Search