Skip to content

Instantly share code, notes, and snippets.

@gamesbook
Forked from spalladino/mysql-docker.sh
Last active May 8, 2022 06:28
Show Gist options
  • Save gamesbook/82ab52993d5a27f759bc5928ffbfdc3f to your computer and use it in GitHub Desktop.
Save gamesbook/82ab52993d5a27f759bc5928ffbfdc3f to your computer and use it in GitHub Desktop.
Backup and restore a mysql database from a running Docker mysql container
# Backup
docker exec $CONTAINERID /usr/bin/mysqldump -u root -proot $DATABASE > backup.sql
# Restore
cat backup.sql | docker exec -i $CONTAINERID /usr/bin/mysql -u root -proot $DATABASE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment