REPAIR TABLE

REPAIR TABLE

REPAIR TABLE table_name [,table_name...] [EXTENDED] [QUICK] [USE_FRM]

Repairs a corrupted MyISAM table. With the QUICK option, only the index tree is repaired. With EXTENDED, the index is re-created row by row. With USE_FRM, the index is repaired based upon the data definition file (for when the index is missing or totally corrupted).