Title: Need Prefix Error
Last modified: February 12, 2018

---

# Need Prefix Error

 *  Resolved [ecogmedia](https://wordpress.org/support/users/ecogmedia/)
 * (@ecogmedia)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/need-prefix-error/)
 * I have exported the Drupal DB from the current external host and created a new
   MySQL database on my localhost and imported the data. When I try and do the text
   connection I keep getting the following error.
 * [ERROR] Couldn’t connect to the Drupal database. Please check the Drupal table
   prefix.
 * However looking at the tables I don’t see a table prefix but it will not let 
   me do the import without that field.
 * I ran the plugin on some text data from that external site from the development
   database and worked fine, removed the import to do the full data and getting 
   the error now.

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Kerfred](https://wordpress.org/support/users/kerfred/)
 * (@kerfred)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/need-prefix-error/#post-9968304)
 * You can let the prefix field empty if your Drupal tables don’t have a prefix.
 * Did you import all the Drupal tables on your local MySQL?
    And did you choose
   the right database name?
 *  Thread Starter [ecogmedia](https://wordpress.org/support/users/ecogmedia/)
 * (@ecogmedia)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/need-prefix-error/#post-9969611)
 * Looking at the tables again and the SQL dump file it doesn’t appear that it is
   creating all the tables on the local. This could be the issue so I’ll work at
   getting the import put in all the way, might be timing out during the import 
   and let you know.
 *  Thread Starter [ecogmedia](https://wordpress.org/support/users/ecogmedia/)
 * (@ecogmedia)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/need-prefix-error/#post-9969788)
 * That seemed to be the issue with the missing tables and I’m able to connect now.
   However it doesn’t appear to be pulling in all the posts so I’ll have to double
   check to make sure the tables are pulling all the way in.
 *  Thread Starter [ecogmedia](https://wordpress.org/support/users/ecogmedia/)
 * (@ecogmedia)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/need-prefix-error/#post-9970574)
 * Ok, I’ve got a clean install and checked the node_revision table and see the 
   posts but they are not being imported it.
 *  Plugin Author [Kerfred](https://wordpress.org/support/users/kerfred/)
 * (@kerfred)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/need-prefix-error/#post-9986350)
 * Please open a ticket on [https://www.fredericgilles.net/support/](https://www.fredericgilles.net/support/)
   and give details about your issue (screenshot, log).
    We will investigate on 
   your issue.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Need Prefix Error’ is closed to new replies.

 * ![](https://ps.w.org/fg-drupal-to-wp/assets/icon-256x256.png?rev=1490014)
 * [FG Drupal to WordPress](https://wordpress.org/plugins/fg-drupal-to-wp/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/fg-drupal-to-wp/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/fg-drupal-to-wp/)
 * [Active Topics](https://wordpress.org/support/plugin/fg-drupal-to-wp/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/fg-drupal-to-wp/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/fg-drupal-to-wp/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Kerfred](https://wordpress.org/support/users/kerfred/)
 * Last activity: [8 years, 3 months ago](https://wordpress.org/support/topic/need-prefix-error/#post-9986350)
 * Status: resolved