HOSTING KB | HOSTING A/C LOGIN | MY iNFOTYKE LOGIN | SEO TOOLS | BLOG | CONTACT US
Knowledgebase
Help Desk - iNFOTYKE > Help Desk - iNFOTYKE > Knowledgebase

Search help:


Repair crashed MySQL tables

Solution

Table corruption in MySQL is a very frequent issue. This primarily happens due to failed/forced transactions. MySQL primary supports two type of engines MyISAM and InnoDB. It is to be noted that the repair utility provided by MySQL can only be used for tables using MyISAM. Crashed tables using InnoDB cannot be repaired using the repair tool. Now, the commands to repair tables/databases in MySQL are as follows:

mysqlcheck -A  [To check and repair all databases on the server]

mysqlcheck -r Database_name [where Database_name is the name of the database to be checked]

Another thing to be noted here is that the -r option can fix everything except unique keys that aren’t unique.

Control panels like cPanel provide an option to repair tables from the interface itself. In cPanel this can be done via cPanel >> MySQL Databases >> Modify Databases >> Check DB. However, please note that this will work for MyISAM tables only.

 
Was this article helpful? yes / no
Related articles Repair crashed MySQL tables
Repair tables in MySQL
Configuring cPHulk and unblocking your IP
How to drop tables from a database in phpMyAdmin
How to drop tables from a database in phpMyAdmin
Article details
Article ID: 86
Category: VPS
Views: 55
Rating (Votes): Article rated 5.0/5.0 (1)

 
« Go back