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

Question

hello all,

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?

Answer 1

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.

Answer 2

i was not getting output from that table, so i just tried to repair,

any ways thank you.