CODEWITHSUNDEEP
mysql
Saranya
Saranya

Reputation: 1151

Repairing table in mysql

i tried to repair a table in mysql .... but it returned an error like ..

The storage engine for the table doesn't support repair

plz try to help..

Upvotes: 0

Views: 1018

Answers (1)

Emil Vikström
Emil Vikström

Reputation: 91912

Check which storage engine the table is using:

SHOW TABLE STATUS LIKE 'tablename';

REPAIR TABLE only works for the MyISAM, ARCHIVE and (lately) CSV storage engines, according to the documentation. For other storage engines your best bet is to restore the table from backup.

Upvotes: 2

Related Questions