Skip to content

Instantly share code, notes, and snippets.

@khnaim

khnaim/mysql-docker.sh

Forked from spalladino/mysql-docker.sh
Created September 10, 2021 07:32
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save khnaim/c73e2cd4cb3a41638fe39bd19bfbdda4 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
@khnaim
Copy link
Copy Markdown
Author

khnaim commented Sep 10, 2021

Thank you

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