将表从 MyISAM 转换为 INNODB
我只是想将表从 MyISAM 转换为 INNODB。 这是为了使用 testopia 进行 bugzilla 升级。
这个简单的命令失败了。 ALTER TABLE 表名 TYPE = INNODB;
错误 1214 (HY000):使用的表类型不支持 FULLTEXT 索引
我知道它不支持 FULLTEXT 索引,但我希望它进行转换。 在转换之前我是否必须删除表上的全文索引? 有没有办法查询它们并将它们全部删除?
I am simply trying to convert a table from MyISAM to INNODB. This is for a bugzilla upgrade with testopia.
This simple command fails. ALTER TABLE table_name TYPE = INNODB;
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
I know it does not support FULLTEXT indexes, never the less I want it to convert. Would I have to drop the fulltext indexes on the table before conversion? Is there a way to query for them and drop them all?
首先,查看您的
CREATE TABLE
语句:它将向您显示所有全文索引,如下所示:
删除所有这些键:
,然后转换:
First, see your
CREATE TABLE
statement:It will show you all your fulltext indexes like this:
Drop all these keys:
, then convert: