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
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:
Post a Comment