Backup mysql data via msyqldump automatically, trigger backup by crontab
1.3K
dump sql now
docker cp mysqlbackup:/opt/tools/dump-now.sh . ## cp dump script current path
sh dump-now.sh
docker run -it -d -e MYSQL_DB=mydatabase \
-e TZ="Asia/Shanghai" \
-v /etc/localtime:/etc/localtime:ro \
-e MYSQL_HOST=172.170.0.1 \
-e MYSQL_PORT=3306 \
-e MYSQL_USER=root \
-e MYSQL_USER_PASSWORD=root \
-e CRONTAB_DAILY_HOUR=2 \
-e CRONTAB_DAILY_MIN=15 \
-v ./mysqlbackup/data:/var/mysqlbackup/data \
-v /var/log/mysqlbackup:/var/mysqlbackup/log \
-w /var/mysqlbackup
zele/mysqlbackup
version: "3"
services:
mysqlbackup:
image: zelejs/mysqlbackup
container_name: mysqlbackup
volumes:
- /etc/localtime:/etc/localtime:ro
- ./mysqlbackup/data:/var/mysqlbackup/data
- /var/log/mysqlbackup:/var/mysqlbackup/log
environment:
MYSQL_DB: db_name
MYSQL_HOST: 172.17.0.1
MYSQL_PORT: 3306
MYSQL_USER: root
MYSQL_USER_PASSWORD: root
CRONTAB_DAILY_HOUR: 2
CRONTAB_DAILY_MIN: 15
Content type
Image
Digest
sha256:c5ce5a8cf…
Size
13.8 MB
Last updated
about 3 years ago
docker pull zelejs/mysqlbackup