Migrating from local sqlite db file to mysql

[Documentary_Man]

Hi so I have been working on my first project with strapi & I’v just finished it, I’ve been using sqlite local db file as a database, now I want to export the data from this local db and import it to mysql, I tried to convert the local db to .sql file using sqlite2 and import it to mysql but this didn’t work.

[Mauricio_van_der_Mae]

@Documentary_Man

been working on my first project with strapi & I’v just finished it, I’ve been using sqlite local db file as a database, now I want to export the data from this local db and import it to mysql, I tried to convert the local db to .sql file using sqlite2 and import it to mysql but this didn’t work.

Hi… I’m dealing with the same issue…
This is what I’ve tried so far, but I’m still not succeeding in the migration.
Please share your process if you were more lucky .

[Mauricio_van_der_Mae]

I forgot to link:

Sqlite to mysql migration

After a couple days of research, I noticed that it’s a pretty common problem to start (intentionally of by accident) a new Strapi instance using SQLite and then make efforts to switch to MySQL. I’ll describe here my journey on this subject: I created a new fresh strapi instance and tried using the export - import method, but didn’t work I also used sqlite3 .dump > data.sql to then create the MySQL data, but it also failed I fixed many Syntax errors in the dumped file, but still failed due to…