RagedUnicorn/docker_mysql_backup_and_restore.md

Created August 17, 2018 09:39

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/RagedUnicorn/00387f150c67be39a1c603425c060cee.js"></script>
Save RagedUnicorn/00387f150c67be39a1c603425c060cee to your computer and use it in GitHub Desktop.

Download ZIP

Docker backup or restory mysql

Raw

docker_mysql_backup_and_restore.md

Docker MySQL Backup and Restore

Create a Backup

docker exec [CONTAINER] /usr/bin/mysqldump -u[user] -p[password] [DATABASE] > backup.sql

Restore a Backup

cat backup.sql | docker exec -i [CONTAINER] /usr/bin/mysql -u[user] -p[password] [DATABASE]

Note: Container in this case can be either part or the full container id or the full container name.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment