WordPress.org

Ready to get started?Download WordPress

Forums

SQLite Integration
Addon idea: export mysql to sqlite (7 posts)

  1. xx
    Member
    Posted 2 months ago #

    I think that could be nice addon, as it's hard to make core exporter/importer to make smooth migration.

    https://wordpress.org/plugins/sqlite-integration/

  2. kjmtsh
    Member
    Plugin Author

    Posted 2 months ago #

    Hi, xx

    Thank you for your suggestion. Nice idea indeed!

    I've been wondering if that feature would help users since I added the MySQL switch feature. I'll try it in the future release.

  3. xx
    Member
    Posted 2 months ago #

    Hi.
    Thank you for answer.
    I think it could help some users to help them move their blogs from current, ordinary installation of existing blogs to your solution.
    Having a switch is nice idea but doesn't help much if you already run your blog and would like to move your MySQL database into SQLite.
    Maybe i do something wrong but when i tried to export/import my 100 mb database by using wordpress export/import plugins it's just doesnt work. Works amazing for smaller blogs :)

  4. kjmtsh
    Member
    Plugin Author

    Posted 2 months ago #

    Will you give me some more details?

    Which operation failed? Exporting the data from MySQL or importing to SQLite? Did you use phpMyAdmin or WordPress built-in exporter or some other plugins? What was the import plugin?

    Thanks.

  5. xx
    Member
    Posted 2 months ago #

    I used wordpress built in exporter and importer.
    My database contains large number of tags about (20k), over 1k posts and also large media library.
    It failed on various steps - sometimes it stops on posts, tags or media. I tried to convert on local server with maximum php resources set, and on my hosting account as well.
    Also, wordpress export doesn't include custom plugin tables, like NextGenGallery, which I was using for some time, and, if possible, i would like to use in sqlite integration.
    Unfortunatelly i have very little experience of sqlite databases, i have had oportunity to use it when plugin 'pdo to wp' was out, and wordpress import/export is only known (for me) way of converting database from mysql to sqlite.
    Blog i try to convert is discontinued, and i like to keep it with minimal resources on my server used. Also, this is my first attempt to use sqlite on database about 100 mb in size.
    Thank you.

  6. kjmtsh
    Member
    Plugin Author

    Posted 2 months ago #

    Thank you for information.

    It's too bad that WordPress built-in exporter didn't work properly. It is more simple and has less functionality than phpMyAdmin. If you want to export the data from the tables created by plugins, the latter is a better solution. Export table schema as well as the data in it, MySQL will create the non-existent tables if needed when importing.

    My plugin doesn't have that import functionality. I'd like to add that feature in the future release, but the next one won't include it. It will take much more time, I'm afraid.

    Your information and suggestion are very useful for me to know various cases. Thank you again!

  7. xx
    Member
    Posted 2 months ago #

    For now i will just stay on mysql then, looking foward for next updates.
    Thanks for doing and maintaining it, it's awesome plugin, my very favorite.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.