A small container for running mysqldump (directly or as cron).
1M+
3.18 latest)3.17)3.16)3.15)3.14)3.13)3.12)3.11)3.10)3.9)3.8)3.7)3.6)3.4)This container can be used in two ways. It is prepared to run crond by default, so you can integrate this container in your docker-compose.yml and do regularly backups defined by a crontab and backup script.
Additionaly you can use this container to create single backups. In this case scroll to the very bottom of this documentation.
Here is an example configuration for using the container with a crontab.
.
├── backup
├── bin
│ ├── backup
│ └── crontab
└── docker-compose.yml
bin folder:$ ls -al
total 16
drwxrwxr-x 2 whoami whoami 4096 Feb 25 17:51 .
drwxrwxr-x 4 whoami whoami 4096 Feb 25 17:51 ..
-rwx------ 1 root root 175 Feb 25 17:51 backup
-rw------- 1 root root 69 Feb 25 17:51 crontab
Mind the file permissions!
chown 0:0 backup && chmod 700 backup
chown 0:0 backup && chmod 600 crontab
version: '2'
services:
db:
image: mariadb:10.1
restart: always
environment:
MYSQL_ROOT_PASSWORD: password
MYSQL_USER: user
MYSQL_PASSWORD: password
MYSQL_DATABASE: database
cron:
image: schnitzler/mysqldump
restart: always
volumes:
- ./bin/crontab:/var/spool/cron/crontabs/root
- ./bin/backup:/usr/local/bin/backup
volumes_from:
- backup
command: ["-l", "8", "-d", "8"]
environment:
MYSQL_HOST: db
MYSQL_USER: user
MYSQL_PASSWORD: password
MYSQL_DATABASE: database
backup:
image: busybox
volumes:
- ./backup:/backup
#minute hour day month week command
0 0 * * * /usr/local/bin/backup
#!/bin/sh
now=$(date +"%s_%Y-%m-%d")
/usr/bin/mysqldump --opt -h ${MYSQL_HOST} -u ${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DATABASE} > "/backup/${now}_${MYSQL_DATABASE}.sql"
The container has a proper crontab by default:
# do daily/weekly/monthly maintenance
# min hour day month weekday command
*/15 * * * * run-parts /etc/periodic/15min
0 * * * * run-parts /etc/periodic/hourly
0 2 * * * run-parts /etc/periodic/daily
0 3 * * 6 run-parts /etc/periodic/weekly
0 5 1 * * run-parts /etc/periodic/monthly
If these execution times suffice, you can simply mount your backup script into the proper folder:
version: '2'
services:
...
cron:
image: schnitzler/mysqldump
restart: always
volumes:
- ./bin/backup:/etc/periodic/daily/backup
volumes_from:
- backup
command: ["-l", "8", "-d", "8"]
environment:
MYSQL_HOST: db
MYSQL_USER: user
MYSQL_PASSWORD: password
MYSQL_DATABASE: database
...
In this case you simply empty the entrypoint and run the mysqlump command.
docker run \
--rm --entrypoint "" \
-v `pwd`/backup:/backup \
--link="container:alias" \
schnitzler/mysqldump \
mysqldump --opt -h alias -u user -p"password" "--result-file=/backup/dumps.sql" database
Content type
Image
Digest
sha256:a84aff36e…
Size
21.6 MB
Last updated
over 3 years ago
docker pull schnitzler/mysqldump