Skip to content

Instantly share code, notes, and snippets.

@stefanopascazi

stefanopascazi/dump-restore.sh

Created February 10, 2022 09:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stefanopascazi/4fb630148d3bdf83de721d02ad3dbc21 to your computer and use it in GitHub Desktop.
Save stefanopascazi/4fb630148d3bdf83de721d02ad3dbc21 to your computer and use it in GitHub Desktop.
Download ZIP
Dump Or Restore MySQL from a container
Raw
dump-restore.sh
#!/bin/bash
## mysqldump
docker exec -i CONTAINER_NAME /usr/bin/mysqldump -u DB_USER -p'DB_PASS' DB_NAME > dump.sql
## Restore
cat dump.sql | docker exec -i CONTAINER_NAME /usr/bin/mysql -u DB_USER -p'DB_PASS' DB_NAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment