Home > DeveloperSection > Interviews > How can we repair a MySQL table?

Posted on    March-18-2011 12:00 AM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  982  View(s)
Rate this:

Sanjay Sharma
Sanjay Sharma

Total Post:42

Points:210
Posted on    March-18-2011 12:00 AM

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.

Modified On Apr-04-2016 12:53:33 AM

Don't want to miss updates? Please click the below button!

Follow MindStick