Swap default database SQLite to MYSql

Questions and Answers
1
System Information
  • Strapi Version: 3.4.0
  • Operating System: Mac OS (Linux)
  • Database: SQLite
  • Node Version: v12.18.3
  • NPM Version: 6.14.6
  • Yarn Version: 1.22.4

I wanna swap my SQLite database to Mysql, I read the docs. it only way is create from a new project to generate the database what i choose. It’s ok to lose all my data in SQLite if there has a way to swap database instead re-do again. Hope there has a way to do it, please update me. Thanks.

2

The best way i’ve found is using sqlite3-to-mysql · PyPI

╰─ sqlite3mysql -f data.db -h 127.0.0.1 -P 3306 -d dbname -u root

3

I tried this but didn’t work for me .
Did you swap on the same instance, of attached the mysql to a new instance?