I made simple PHP script to convert .sql
file from SQLite to MariaDB/MySQL format. First dump your SQLite data:
bash
sqlite3 sqlite.sqlite .dump > sqlite.sql
Then, download the script:
bash
curl -o script.php https://raw.githubusercontent.com/huedaya/sqlite3-to-mariadb-format/main/script.php
To convert simply run:
bash
php script.php sqlite.sql > output.mariadb.sql
To read more detail please check the repo.
That's it!