1 like 0 dislike
2k views
in Education & Reference by (640 points)

After repairing table of one of my database I have received the following error:

The storage engine for the table doesn't support repair

1 Answer

0 like 0 dislike
by (850 points)

First is you have to understand the difference between MyISAM and InnoDB Engines

 

  • The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction

Most people use MyISAM if they need speed and InnoDB for data integrity. You can use more than one or any combination of these table types in your database. 

You can use this sql statement if you want to convert InnoDB to MyISAM:
 ALTER TABLE table_one ENGINE=MyISAM;

by (850 points)
0 0
They are most probably InnoDB tables, InnoDB tables don't require and/or can't be repaired with the repair function.
Only MyISAM tables can be,

Related questions

0 like 0 dislike
1 answer 103 views
0 like 0 dislike
1 answer 800 views
0 like 0 dislike
1 answer 503 views
0 like 0 dislike
3 answers 743 views
0 like 0 dislike
1 answer 134 views
1 like 0 dislike
1 answer 55 views
0 like 0 dislike
1 answer 168 views
1 like 0 dislike
1 answer 3 views
0 like 0 dislike
1 answer 570 views
...