Syntax:
REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE
    tbl_name [, tbl_name] ...
    [QUICK] [EXTENDED] [USE_FRM]

REPAIR TABLE repairs a possibly corrupted table. By default, it has the
same effect as myisamchk --recover tbl_name. REPAIR TABLE works for
MyISAM and for ARCHIVE tables. Starting with MySQL 5.1.9, REPAIR is
also valid for CSV tables. See
http://dev.mysql.com/doc/refman/5.1/en/myisam-storage-engine.html, and
http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html, and
http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.html

This statement requires SELECT and INSERT privileges for the table.

Beginning with MySQL 5.1.27, REPAIR TABLE is also supported for
partitioned tables. However, the USE_FRM option cannot be used with
this statement on a partitioned table.

Also beginning with MySQL 5.1.27, you can use ALTER TABLE ... REPAIR
PARTITION to repair one or more partitions; for more information, see
[HELP ALTER TABLE], and
http://dev.mysql.com/doc/refman/5.1/en/partitioning-maintenance.html.

URL: http://dev.mysql.com/doc/refman/5.1/en/repair-table.html

