Pages

Monday, May 16, 2011

MySQL: Correct problems in corrupted MyISAM, ARCHIVE and CSV tables


Correct problems in corrupted MyISAM, ARCHIVE and CSV tables


Following are the steps to recover corrupted tables - for above mentioned engine -


CHECK TABLES table1 ,table2;


REPAIR TABLE table1;


REPAIR TABLE table1 EXTENDED;


REPAIR TABLE table1 USE_FRM;


CHECK TABLE table1;

No comments: