MySQL Repair Table

Occasionally tables from MySQL become corrupted, which leads to the loss of readability, and when attempted to read from this corrupted table might result in the server crashing. While this happens, the REPAIR TABLE command repairs a corrupted table and fixes the issue sometimes.

Although note that this statement requires SELECT and INSERT privileges for the table. In the average case, the REPAIR TABLE is not needed to run until a disaster strikes. This statement is likely to get all our data back.

MySQL Repair Table Syntax

REPAIR TABLE table_name;

Repair Table Storage Engine

REPAIR TABLE works for MyISAM, ARCHIVE, and CSV tables.
The statement does not work with views.

Repair Table Options

NO_WRITE_TO_BINLOG or LOCAL: This option is used to suppress logging to the binary log.
QUICK: This option repairs only the index file and not the data file.
EXTENDED: When using this option, MySQL creates the index row by row instead of creating one index at a time with sorting.
USE_FRM: This is used when the .MYI index file is missing or its header is corrupted.