Sunday, July 17, 2011

How can we repair a MySQL table?

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.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home