Migrating from a MySQL backed database to SQLite?

[davidwinter]

Is there a recommended approach to migrating an existing MySQL backed site to use SQLite and this plugin? Installing the plugin currently installs a new SQLite database and states you start afresh.

[tassoman]

"A long time ago in a galaxy far, far away...." I used to migrate my old old blog from Drupal, back to WordPress.
In both the situations I used the WXR feature, the first to extract data to Drupal, and some year after, exporting back to WP.
Today we have also WPCLI helping.
So, I guess you can have two installations, extract data from mysql version into a static WXR file. Finally import it in the SQLite WP.
I guess can work somehow. 🤔

[Raboo]

The wp export WXR files do not include site configuration (options). So I guess more steps are required to get the configuration out of the MySQL into SQLite

[tassoman]

Good point. It depends by actual plugin's installation procedure. If it's migrating options table also, you could go on with your existing website, plugins included. Otherwise, if it's doing it from scratch, you're going to have a clean newborn WP installation.

In the first situation, I guess the only thing missing would be content, that's why I suggested exporting, then re-importing it by WRX feature. I'm not very sure about SQLite integration business model, so my words are pure theorical suppositions.