Senin, 02 Februari 2015

mysqldump: Error : Table is marked as crashed and should be repaired when dumping table

mysqldump: Error : Table is marked as crashed and should be repaired when dumping table

Usually we will get this error while dumping database .
Solution :-

1) Repair the crashed table

# mysql -u user -p pass
>  use database ;
> REPAIR TABLE `tablename`;
2) Repair the complete database
#  check for errors or which are tables are corrupted or not closed properly
# cd /var/lib/mysql/DATABASE
# myisamchk -s *.MYI
will give the status
# myisamchk -r  *.MYI

Tidak ada komentar:

Posting Komentar