Title: Importing a Drupal SQLite DB?
Last modified: October 30, 2017

---

# Importing a Drupal SQLite DB?

 *  Resolved [tgp1994](https://wordpress.org/support/users/tgp1994/)
 * (@tgp1994)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/importing-a-drupal-sqlite-db/)
 * I have an old-er Drupal installation that I’d like to migrate over to the current
   version of WordPress on my own host. Unfortunately, the Drupal installation is
   using an sqlite database. I’ve tried dumping it to an .SQL file, but phpmyadmin
   struggles with important it into a new MySQL database (it trips on syntax errors
   in insert statements). What is the best way to get my data out of this drupal
   SQLite database and in to WordPress?

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

 *  [HudsonValleyWebDesign](https://wordpress.org/support/users/jaycbrf/)
 * (@jaycbrf)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/importing-a-drupal-sqlite-db/#post-9633724)
 * [https://wordpress.org/plugins/fg-drupal-to-wp/](https://wordpress.org/plugins/fg-drupal-to-wp/)
 * As far as exporting to MySQL, not sure about the errors
    -  This reply was modified 8 years, 7 months ago by [HudsonValleyWebDesign](https://wordpress.org/support/users/jaycbrf/).
 *  Thread Starter [tgp1994](https://wordpress.org/support/users/tgp1994/)
 * (@tgp1994)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/importing-a-drupal-sqlite-db/#post-9634190)
 * Thank you! I’m actually familiar with that plugin, that’s one of the first things
   I tried (should have mentioned that, sorry). It doesn’t seem to support importing
   from Drupal if drupal is configured to use a sqlite database. I felt the need
   to move my drupal installation over to mysql, but that introduces its own set
   of problems.
 * Regarding the syntax errors, here’s an example. One line that stops the import
   is;
 *     ```
       INSERT INTO "variable" VALUES('theme_default','s:9:"newsflash";');
       ```
   
 * And the error is;
 * > #1064 – You have an error in your SQL syntax; check the manual that corresponds
   > to your MySQL server version for the right syntax to use near ‘”variable” VALUES(‘
   > theme_default’,’s:9:”newsflash”;’)’ at line 1
 * Thinking it may have been the semicolon within the string, I tried escaping it
   with _\;_ which didn’t work. Guessing it may have been the nested double quotes,
   I tried changing them over to single quotes, and that didn’t work either.
 * I’m starting to have flashbacks to programming with MySQL…
    -  This reply was modified 8 years, 7 months ago by [tgp1994](https://wordpress.org/support/users/tgp1994/).
 *  Thread Starter [tgp1994](https://wordpress.org/support/users/tgp1994/)
 * (@tgp1994)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/importing-a-drupal-sqlite-db/#post-9634296)
 * Update: It looks like I’ve solved it, and it was pretty easy to boot. Here’s 
   what I did:
 * First, I configured my Drupal settings.php file to have two database connections,
   adding in a connection to an empty mysql database alongside the pre-existing 
   connection to the sqlite database. Then, I installed the [DBTNG Migrator](https://www.drupal.org/project/dbtng_migrator)
   in Drupal. Then I enabled the Migrator plugin in Drupal and opened its settings.
   From there, I could see both of my database connections. I made sure the origin
   and destination fields were set correctly, then all I had to do was click the
   migrate button. I verified that all of my data had moved by looking at phpmyadmin.
 * Next, WordPress. I added the FG Drupal to WordPress plugin and clicked the “Import”
   link. I added my database settings, tested the connection, and then ran the import.
   No problem!

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

The topic ‘Importing a Drupal SQLite DB?’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [tgp1994](https://wordpress.org/support/users/tgp1994/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/importing-a-drupal-sqlite-db/#post-9634296)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics