Dump And Restore Databases From Dockerized Mysql
Posted on April 14, 2025
Quick way to dump and restore db’s in a dockerized mysql db
Dump
docker exec some-mysql-container sh -c 'exec mysqldump -D db-name -uroot -p"$MYSQL_ROOT_PASSWORD"' > /some/path/on/your/host/all-databases.sql
Restore
docker exec -i some-mysql-container sh -c 'exec mysql -D db-name -uroot -p"$MYSQL_ROOT_PASSWORD"' < /some/path/on/your/host/all-databases.sql
Hey! I'll happily receive your comments
via email.
Thanks for reading.
Andreas Wagner
freelance System Administrator and Ruby programmer in Tallinn, Estonia