Migrate SQLite3 to MySQL

[space2018]

Hi,

 

Does anyone know how to migrate SQLite3 schema and data to a MySQL-compatible database? For technical reasons, I need SQLite 3.8 which is not supported and have been advised to use MySQL, which works great... But how do I migrate the data?

 

[wolstech]

You’ll need to export the data from the existing format as something easy to work with like CSV, then import it into the new database.

 

In my personal experience, where possible it’s best to just start over.