1.

How Can We Repair A Mysql Table?

Answer»

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

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


Discussion

No Comment Found

Related InterviewSolutions