How can we repair a MySQL table?

Question

Anonymous User · Answer

The syntex for repairing a mysql table is:
REPAIR TABLE tablename
REPAIR TABLE tablename QUICK
REPAIR TABLE tablename EXTENDED
This command will repair the table specified.
If QUICK is given, MySQL will do a repair of only the index tree.
If EXTENDED is given, it will create index row by row.

interview

How can we repair a MySQL table?

Can you answer this question?

1 Answers