Skip to content

SQLite to MariaDB Migration of Existing Data

cd ./flask/database
sqlite3 database.sqlite3 .dump > database.sql
sed -i '/^INSERT INTO/!d' database.sql
sed -i 's/^INSERT //' database.sql
sed -i 's/^/INSERT IGNORE /' database.sql
sed -i '1s/^/USE db;\n/' database.sql
docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' 19sq-mariadb
mysql -h <docker_ip> -u root -p < database.sql
Edited by Lars Florian Meiendresch