Sign inSign up

zelejs/mysqlbackup

By zelejs

Updated about 3 years ago

Backup mysql data via msyqldump automatically, trigger backup by crontab

Image
0

1.3K

zelejs/mysqlbackup repository overview

Usage

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

docker-compose.yaml

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 

Tag summary

Content type

Image

Digest

sha256:c5ce5a8cf

Size

13.8 MB

Last updated

about 3 years ago

docker pull zelejs/mysqlbackup