将表从MyISAM转换为INNODB [英] Converting table from MyISAM to INNODB

问题描述

我只是想将表从MyISAM转换为INNODB.这是针对具有testopia的Bugzilla升级.

I am simply trying to convert a table from MyISAM to INNODB. This is for a bugzilla upgrade with testopia.

此简单命令失败. ALTER TABLE table_name TYPE = INNODB;

This simple command fails. ALTER TABLE table_name TYPE = INNODB;

错误1214(HY000):使用的表类型不支持FULLTEXT索引

ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

我知道它不支持FULLTEXT索引，但是我不希望它转换.转换之前，我是否必须在表上删除全文索引?有没有办法查询它们并将它们全部删除?

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语句:

SHOW CREATE TABLE tablename

它将向您显示所有全文索引，如下所示:

It will show you all your fulltext indexes like this:

…,
FULLTEXT KEY key_name (column_list),
…

丢弃所有这些键:

ALTER TABLE tablename DROP INDEX key_name;
…

，然后进行转换:

ALTER TABLE tablename ENGINE=InnoDB;

这篇关于将表从MyISAM转换为INNODB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！