The storage engine for the table doesn't support repair. InnoDB or MyISAM?
mysql
Solution
First is you have to understand the difference between `MyISAM` and `InnoDB` Engines. And this is clearly stated on this link. You can use this sql statement if you want to convert InnoDB to MyISAM:
ALTER TABLE t1 ENGINE=MyISAM;
Problem
After repairing my database I received the following error: ``` scode_tracker.ap_visits note : The storage engine for the table doesn't support repair scode_tracker.visit_length note : The storage engine for the table doesn't support repair ``` I found out that the type of table is InnoDB. The other table was MyISAM and it was repaired successfully. After reading some topic here, the solution is to change it to MyISAM. I don't know much about InnoDB and MyISAM. I don't specify the type when I created the table. So my question is should I use MyISAM instead of InnoDB? If yes, how can I change it from InnoDB to MyISAM?