Home »

How can we repair a MySQL table?

Question ListCategory: PHPHow can we repair a MySQL table?
denielshakespeare5 author asked 9 years ago
2 Answers
milleranthony7 author answered 8 years ago

The syntex for repairing a MySQL table is REPAIR TABLENAME, [TABLENAME, ], [Quick],[Extended].This command will repair the table specified if the quick is given the MySQL will do a repair of only the index tree if the extended is givenit will create index row by row.

jessica537 author answered 8 years ago

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.

Please login or Register to Submit Answer