Skip to content

Instantly share code, notes, and snippets.

@ChrisTaylorDeveloper

ChrisTaylorDeveloper/mysqldump-remote-database-with-local-docker-image.md

Created May 11, 2020 07:33
Show Gist options
  • Save ChrisTaylorDeveloper/e0c0daedd3bc066e7d275a41d5c0c4f7 to your computer and use it in GitHub Desktop.
Save ChrisTaylorDeveloper/e0c0daedd3bc066e7d275a41d5c0c4f7 to your computer and use it in GitHub Desktop.
Download ZIP
Run mysqldump on remote database using local docker image
Raw
mysqldump-remote-database-with-local-docker-image.md

When no mysql tools are available locally, use mysqldump from inside a docker container to backup a remote database.

docker run -it --rm -e MYSQL_PWD=<user pass> mysql:5.7 mysqldump -u <user> -h <ip address> -P 3306 database 1> backup.sql

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