Addon idea: export mysql to sqlite

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.

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 ??

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.

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.

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!

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.