How can we repair a MySQL table?

Last updated 3 years, 2 months ago | 683 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.