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

Concat tidak berfungsi untuk indexing

 $sql = "SELECT a.* , CONCAT(a.Kode_Barang,'<br><b>',b.Nm_Aset5,'</b>') as Nm_Aset5, CONCAT(a.latitud...