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

  1. xx
    Posted 6 years ago #

    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.


  2. jpadie
    Posted 6 years ago #

    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.

    (author of PDO For WordPress)

  3. ivancastell
    Posted 6 years ago #


    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?

  4. unknownclubber
    Posted 5 years ago #

    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.


Topic Closed

This topic has been closed to new replies.

About this Topic