Title: [Plugin: PDO (SQLite) For WordPress] How to convert mysql database into sqlite?
Last modified: August 19, 2016

---

# [Plugin: PDO (SQLite) For WordPress] How to convert mysql database into sqlite?

 *  [xx](https://wordpress.org/support/users/piotrostr/)
 * (@piotrostr)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/plugin-pdo-sqlite-for-wordpress-how-to-convert-mysql-database-into-sqlite/)
 * Hi, i love this idea to run wp on sqlite database, i have few 😉 blogs, many 
   of them running on db larger than 10 mb, so, what i mean it’s a lot posts to 
   re-write 🙂 Is there any simple tool which can help me to convert my old mysql-
   based db’s into sqlite?
    Thanks in advance.
 * [http://wordpress.org/extend/plugins/pdo-for-wordpress/](http://wordpress.org/extend/plugins/pdo-for-wordpress/)

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

 *  [jpadie](https://wordpress.org/support/users/jpadie/)
 * (@jpadie)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-pdo-sqlite-for-wordpress-how-to-convert-mysql-database-into-sqlite/#post-1243426)
 * Hi Piotrostr
 * in principal you need no special tool. just use the export/import function in
   wordpress and between the two, specify the DB_TYPE in your wp-config.
 * let me know if that does not work and i will write a tool to do the migration.
 * Justin
    (author of PDO For WordPress)
 *  [ivancastell](https://wordpress.org/support/users/ivancastell/)
 * (@ivancastell)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/plugin-pdo-sqlite-for-wordpress-how-to-convert-mysql-database-into-sqlite/#post-1243454)
 * Hi,
 * I’ll also like to migrate from mysql to sqlite and I can export and then import
   my posts, comments, etc… but other configuration stuff related to the database
   like plugins, themes, etc… are lost. I mean the pugins and themes are there, 
   but all settings are back to defaults, and importing the xml just restore the
   content of the blog. As I run a customized wordpress version (theme and plugins)
   I’ve reverted back to default mysql.
 * Is there some plans to enable some migration tools or it’s just not possible?
 *  [unknownclubber](https://wordpress.org/support/users/unknownclubber/)
 * (@unknownclubber)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/plugin-pdo-sqlite-for-wordpress-how-to-convert-mysql-database-into-sqlite/#post-1243464)
 * Hi jpadie !
 * 1st of all, thanks for this nice plugin. But i can’t install it. I’ve tried to
   find solutions on the net but, it seemes that most of the time, you are the only
   one who knows how-to.
    Actually I’m french and i guess you too. (I write in english
   for others WP users) Is there a way to contact you? I got 1 or 2 questions about
   install. After install, i got : **Fatal error:** Call to a member function bail()
   on a non-object in … I’ve changed permissions on different files/folders without
   success. I have PDO / SQLite / pdo_sqlite enabled (phpinfo), but it still doesn’t
   work ! Please help, i’m really interested in your solution.
 * “Merci”

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

The topic ‘[Plugin: PDO (SQLite) For WordPress] How to convert mysql database into
sqlite?’ is closed to new replies.

 * 3 replies
 * 4 participants
 * Last reply from: [unknownclubber](https://wordpress.org/support/users/unknownclubber/)
 * Last activity: [15 years, 8 months ago](https://wordpress.org/support/topic/plugin-pdo-sqlite-for-wordpress-how-to-convert-mysql-database-into-sqlite/#post-1243464)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics