Friday, July 12, 2013

How to Repair MYSQL Table

When i am taking mysqldump, it shows "a table reported as crashed and need to be repaired".
Repair Table in phpmyadmin could not repair it.

[root@akwal ~]# mysql -u username -p
mysql> show databases;

use efected db name you want to repair
mysql> use dbname;

To check table name
mysql> show tables tableName;

using "repair table" command
mysql> repair table tableName;

when repaired it shows OK.
to exit
mysql> quit

0 comments: