该表的存储引擎不支持修复.是InnoDB还是MyISAM? [英] The storage engine for the table doesn't support repair. InnoDB or MyISAM?

问题描述

修复数据库后，出现以下错误:

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

我发现表的类型是InnoDB.另一个表是MyISAM，它已成功修复.

I found out that the type of table is InnoDB. The other table was MyISAM and it was repaired successfully.

在这里阅读了一些主题之后，解决方案是将其更改为MyISAM.我对InnoDB和MyISAM不太了解.创建表时没有指定类型.所以我的问题是我应该使用MyISAM而不是InnoDB吗?如果是，如何将其从InnoDB更改为MyISAM?

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?

推荐答案

首先，您必须了解MyISAM和InnoDB引擎之间的区别.在 链接 .如果要将 InnoDB转换为MyISAM ，可以使用此sql语句:

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;

这篇关于该表的存储引擎不支持修复.是InnoDB还是MyISAM?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！