php - MySQL error when copying/importing database
the premise to my problem is this: I know very little about MySQL, and I have a MySQL database of a wordpress blog that I'm trying to copy between two instances of XAMPP, from one under OS X, to the other under Windows 7. I assume they both are InnoDB, not sure, though. Both XAMPP versions are the latest to date.
I export the database to an .sql file with all the default settings and then try to import it into an empty database of the same name, when it gets to this table
Indexes for table
ALTER TABLE `wp_posts` ADD PRIMARY KEY (`ID`), ADD KEY `post_name` (`post_name`), ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`), ADD KEY `post_parent` (`post_parent`), ADD KEY `post_author` (`post_author`), ADD FULLTEXT KEY `crp_related` (`post_title`,`post_content`), ADD FULLTEXT KEY `crp_related_title` (`post_title`), ADD FULLTEXT KEY `crp_related_content` (`post_content`);
I get this error:
#1795 - InnoDB presently supports one FULLTEXT index creation at a time
What should I do to succesfully copy the database over?
I understand it's an InnoDB bug of some kind, Googling the exact error phrase I found this thread MySQL Error When Copying or Importing Database but I don't know enough to understand what the OP did to his db so it worked...
I also found this http://sourceforge.net/p/phpmyadmin/feature-requests/1553/ I understand this is directly related to the error i'm getting, and that it probably tells a solution ("That is why PhpMyAdmin at export should separate creation of FULLTEXT indexes into few SQL commands") but I don't know enough to understand that either, and Googling further about FULLTEXT only finds pages about "fulltext search" function.
But what should I DO, exactly? Please advice.