php - MySQL error when copying/importing database

845

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 tablewp_posts

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.

People are also looking for solutions to the problem: php - register including post fail

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.