How can we repair a MySQL table?

Last updated 5 years, 7 months ago | 1351 views 75     5

Tags:- MySQL

MySQL | Repair Table

REPAIR command is used for repair a MySQL table

REPAIR TABLE users

We can also specify Quick and Extended after the table name

REPAIR TABLE users QUICK

If we specify Quick then MySQL will do a repair of only the index tree.

REPAIR TABLE users EXTENDED

 But if we specify the extended then it creates index row by row.