作者:小晶晶妮妮宝贝 | 来源:互联网 | 2024-11-03 19:47
While exporting structure of table with few FULLTEXT indexes PhpMyAdmin exports all indexes together
While exporting structure of table with few FULLTEXT indexes PhpMyAdmin exports all indexes together, namely:
ALTER TABLE
ADD FULLTEXT KEY
(
), ADD FULLTEXT KEY
(
);
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.
- Original URL: https://sourceforge.net/p/phpmyadmin/feature-requests/1553/
- Original author: nazar-pc
该提问来源于开源项目:phpmyadmin/phpmyadmin
- Status: resolved --> fixed