HOW CAN WE REPAIR A MYSQL TABLE?

Arun Singh

Total Post:309

Points:1545
Posted by  Arun Singh
PHP 
PHP
 2286  View(s)
Ratings:
Rate this:
  1. Arun Singh

    Post:309

    Points:1545
    How can we repair a MySQL table?

    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.

Answer

NEWSLETTER

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