#1553 (ok 4.4) Error #1795 - InnoDB presently supports one FULLTEXT index creation at a time

[Nazar Mokrynskyi]

While exporting structure of table with few FULLTEXT indexes PhpMyAdmin exports all indexes together, namely:

ALTER TABLE table_name ADD FULLTEXT KEY text1 (text1), ADD FULLTEXT KEY text2 (text2);

And because of this on import you'll get:

#1795 - InnoDB presently supports one FULLTEXT index creation at a time

That is why PhpMyAdmin at export should separate creation of FULLTEXT indexes into few SQL commands.

[Madhura Jayaratne]

PR https://github.com/phpmyadmin/phpmyadmin/pull/1401

[Marc Delisle]

This is on MySQL 5.6:
http://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html