curl -O https://gist.githubusercontent.com/sebastian13/cc58304f7b177ac1d16d7671dc67efb9/raw/docker-mysql-dump.sh
curl -O https://gist.githubusercontent.com/sebastian13/cc58304f7b177ac1d16d7671dc67efb9/raw/docker-mysql-restore.sh
MYSQL_DATABASE=example
MYSQL_ROOT_PASSWORD=123456
services:
example-1:
...
env_file: .env
example-2:
...
environment:
- MYSQL_DATABSE=${MYSQL_DATABSE}
- MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
| # Change to the script's directory & create directory | |
| cd $(dirname "$(readlink -f "$0")") | |
| mkdir -p ./dbdumps | |
| # Start mysql service of your compose file | |
| docker-compose up -d mysql | |
| # Load database name + root password | |
| source .env | |
| # Delete old Backups | |
| find ./dbdumps/* -atime +7 -exec rm {} \; | |
| docker-compose exec -T mysql /usr/bin/mysqldump -u root \ | |
| --password=$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE \ | |
| | gzip --rsyncable > ./dbdumps/`date +\%Y\%m\%d`-$MYSQL_DATABASE.sql.gz |
| # Start mysql service of your compose file | |
| docker-compose up -d mysql | |
| # Load database name + root password | |
| source .env | |
| # Find latest dump | |
| latest=$(ls -1t ./dbdumps/*.sql.gz | head -1) | |
| # Restore | |
| gunzip $latest | docker-compose exec -T mysql \ | |
| /usr/bin/mysql -u root --password=${MYSQL_ROOT_PASSWORD} ${MYSQL_DATABASE} |
I just had a problem with
source .env, but replacing this line with. ./.envworked. Thanks for these scripts, amazing work!