HOW CAN WE REPAIR A MYSQL TABLE?

Arun Singh

Total Post:310

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

    Post:310

    Points:1550
    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!