HOW CAN WE REPAIR A MYSQL TABLE?

Sanjay Sharma

Total Post:42

Points:210
Posted by  Sanjay Sharma
MYSQL 
 1146  View(s)
Ratings:
Rate this:
  1. Sanjay Sharma

    Post:42

    Points:210
    How can we repair a MySQL table?

    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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!