CODEWITHSUNDEEP
mysql
M Y T H
M Y T H

Reputation: 107

what to do when ' repair table ' query won't work in mysql?

i got this error : "The storage engine for the table doesn't support repair"

when i tried to repair the table using the query repair table tbl_college_master

table is of innodb type, but i dont know y i'm getting this error?

Upvotes: 7

Views: 10524

Answers (2)

mickjsn
mickjsn

Reputation: 26

I think you should try the mysql repair tool. It's a great tool that can repair any type of MySQL data or table containing any data, and I am sure that it will repair the table using the query repair table tbl_college_master.

Upvotes: 1

Joey
Joey

Reputation: 354436

See the manual—REPAIR TABLE is only applicable to MyISAM, ARCHIVE and CSV storage engines.

With InnoDB you don't need this anyway, as the storage engine can't go into an inconsistent state unlike MyISAM and others.

Upvotes: 13

Related Questions