Title: SQL Error on Import
Last modified: October 8, 2017

---

# SQL Error on Import

 *  [gdavis55](https://wordpress.org/support/users/gdavis55/)
 * (@gdavis55)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/sql-error-on-import/)
 * Hello,
 * I have CRP running on my blog of about 900 posts and it’s working fine.
 * When I export my database and import it to a new database I get this error:
    #
   1795 – InnoDB presently supports one FULLTEXT index creation at a time
 * The error occurs here:
 *  SQL query:
    — — Indexes for table `wp_posts` — ALTER TABLE `wp_posts` ADD PRIMARY
   KEY (`ID`), 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 KEY `post_name` (`post_name`(191)), ADD FULLTEXT KEY `post_related` (`post_name`,`
   post_content`), 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`);
 * Is there a way to prevent this error from occurring when I import the database?
 * My only thought is to deactivate CRP, move the site, then reactivate it. Is there
   a better solution?
 * I’d like to keep using CRP if possible.
 * Thanks,
    Gord
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsql-error-on-import%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/sql-error-on-import/#post-9571087)
 * You can delete that line and then import the rest of the database and it should
   work.
 * Then in the settings page, you’ll have some queries to run (bottom of page) to
   regenerate the index

Viewing 1 replies (of 1 total)

The topic ‘SQL Error on Import’ is closed to new replies.

 * ![](https://ps.w.org/contextual-related-posts/assets/icon-256x256.png?rev=2985705)
 * [Contextual Related Posts](https://wordpress.org/plugins/contextual-related-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contextual-related-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contextual-related-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/contextual-related-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contextual-related-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contextual-related-posts/reviews/)

## Tags

 * [fulltext](https://wordpress.org/support/topic-tag/fulltext/)
 * [import error](https://wordpress.org/support/topic-tag/import-error/)

 * 1 reply
 * 2 participants
 * Last reply from: [Ajay](https://wordpress.org/support/users/ajay/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/sql-error-on-import/#post-9571087)
 * Status: not resolved