Backup and restore a mysql database from a running Docker mysql container

mewcrow
2022-03-07T22:47:16Z

mysql-docker.sh

| # Backup
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
|
| # Restore
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
|