SQLite to MariaDB Migration of Existing Data
-
main !17 (merged) -
stage !19 (merged) -
frederic-deploy !18 (merged) (flask-dev -> nginx-docker)
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