Sign inSign up

vtacquet/mybackup

By vtacquet

•Updated over 3 years ago

lightweight mysql backup container with skip tables and cron

Image
0

1.0K

vtacquet/mybackup repository overview

Description: Creates a lightweight mysql backup container with skip tables and cron support.

environment variables:

MYSQL_HOST=somehost
MYSQL_ROOT_PASSWORD=xxx 
MYSQL_DATABASE=somedatabase 
SKIP_TABLES=table1,table2,table3
CRON=0 22 * * * 
BACKUP_LOCATION=/somelocation
KEEP_ITEMS=5
FORCE=1

docker-compose example:

  mybackup:
    hostname: mybackup
    container_name: mybackup
    image: vtacquet/mybackup:latest
    volumes:
     - /etc/localtime:/etc/localtime:ro
     - /mnt/backups:/backups
    links:
     - mysql
    environment:
     - MYSQL_HOST=mysql
     - MYSQL_ROOT_PASSWORD=xxx
     - MYSQL_DATABASE=production
     - SKIP_TABLES=history,history_log
     - CRON=0 22 * * * 
     - BACKUP_LOCATION=/backups
     - KEEP_ITEMS=5
     - FORCE=1

Tag summary

Content type

Image

Digest

sha256:a988ee630…

Size

145.2 MB

Last updated

over 3 years ago

docker pull vtacquet/mybackup