Convert table from MyISAM to INNODB

Question

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

This simple command does not work. ALTER TABLE table_name TYPE = INNODB;

ERROR 1214 (HY000): the table type used does not support FULLTEXT indexes

I know that it does not support FULLTEXT indices, however I want it to convert. Should I abandon full-text indexes in a table before conversion? Is there any way to request them and delete everything?

Answer 1

First, see the instructions CREATE TABLE:

SHOW CREATE TABLE tablename

It will show you all your full-text indexes, for example:

…,
FULLTEXT KEY key_name (column_list),
…

Drop all these keys:

ALTER TABLE tablename DROP INDEX key_name;
…

:

ALTER TABLE tablename ENGINE=InnoDB;