MySql - SQL Dump

About

A SQL dump is a dump of database in a sql script

Articles Related

Management

They are managed with mysqldump

Creation

With docker

docker exec some-mysql sh -c 'exec mysqldump --all-databases -uroot -p"$MYSQL_ROOT_PASSWORD"' > /some/path/on/your/host/all-databases.sql

Restoring

with docker and the i option

docker exec -i some-mysql sh -c 'exec mysql -uroot -p"$MYSQL_ROOT_PASSWORD"' < /some/path/on/your/host/all-databases.sql