huedaya.com/blog
just bunch of .md files
Convert SQLite to MariaDB/MySQL Format

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!

Last update: 2024-02-18 05:08:29 UTC (7 months ago)