There are three syntax  to repair MySQL table.

  1. REPAIR TABLE table_name
  2. REPAIR TABLE table_name QUICK
  3. REPAIR TABLE table_name EXTENDED

If QUICK is given, MySQL will repair index tree.
If EXTENDED is given, it will create index row by row.

eXTReMe Tracker