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

Total Post:312

Points:1560

Posted on    May-04-2012 8:34 AM

 PHP PHP 
Ratings:
 1 Answer(s)
  1187  View(s)
Rate this:

Arun Singh

Total Post:312

Points:1560
Posted on    May-04-2012 12:00 AM

The syntax 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.

Recent Activities

Mayank Tripathi added new Blog Cloud Computing Concepts: PaaS   14 hours ago


priyanka kushwaha added new Article Security in ASP.NET   19 hours ago

Chris S added new Question Why Java does not support pointers?   4 days ago

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