Skip to content

Instantly share code, notes, and snippets.

@rajat3204

rajat3204/mysql-docker.sh

Forked from spalladino/mysql-docker.sh
Created June 22, 2024 10:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rajat3204/a73eba43c0e17e9057f4a1bee695d4c2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rajat3204/a73eba43c0e17e9057f4a1bee695d4c2 to your computer and use it in GitHub Desktop.
Download ZIP
Backup and restore a mysql database from a running Docker mysql container
Raw
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
@rajat3204
Copy link
Copy Markdown
Author

rajat3204 commented Jun 22, 2024

working for our environment

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