Answers

Question and Answer:

  Home  PHP

⟩ How can we repair a MySQL table?

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.

 167 views

More Questions for you: