#4930 (ok 4.4.8) Database copy doesn't work for tables with more than one FULLTEXT index

[Ivan Zahariev (famzah)]

A database cannot be copied by "Operations" -> "Copy database to", if a table has more than one FULLTEXT indexes. Here is an example:

CREATE TABLE `pages` (
  `name` varchar(64) DEFAULT NULL,
  `title` varchar(64) DEFAULT NULL,
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

If I try to copy the database with this table, I get the following error:

The problem exists for both MyISAM and InnoDB tables, and seems to be introduced by the following new feature: http://sourceforge.net/p/phpmyadmin/feature-requests/1553/

The two FULLTEXT indexes are exported by phpMyAdmin as two SQL statements but the import operation tries to execute both SQL statements as one SQL statement, and hence the SQL error.

---

Platform: PHP 5.5.23 // MySQL 5.6.24-percona.

[Madhura Jayaratne]

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/2b143889049f8304ad4e50bc6ef485b13b2d5956

[Ivan Zahariev (famzah)]

Still not completely fixed. It works with two indexes, but doesn't work with three or more. Please review and fix.

[Madhura Jayaratne]

Thanks for pointing that out. Should be fixed with https://github.com/phpmyadmin/phpmyadmin/commit/a9f3ae7d8e5e81cda6d6d51aad3c462ad9a9bef0