Skip to content

Instantly share code, notes, and snippets.

@brabao
Forked from spalladino/mysql-docker.sh
Last active September 14, 2023 13:46
Show Gist options
  • Save brabao/a0c7ba4ab0995d80d82b833f545e4cf3 to your computer and use it in GitHub Desktop.
Save brabao/a0c7ba4ab0995d80d82b833f545e4cf3 to your computer and use it in GitHub Desktop.
Backup and restore a mariadb database from a running Docker mysql container
# Backup
docker exec CONTAINER mysqldump --routines --triggers --user root --password=root DATABASE > ./backup.sql
# Restore
docker exec -i CONTAINER mysql --user root --password=root DATABASE < ./backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment