/docker-mysql-b2

image to enable automated backups of mysql databases in containers

Primary LanguageShell

MySQL Dump to Backblaze b2

Overview

MySQL dump to Backblaze's b2 storage.

Environment Variables

  • BACKUP_DB_HOST: hostname/ip of the database server
  • BACKUP_DB_USER: username for the database
  • BACKUP_DB_PASSWORD: password for the database
  • BACKUP_DB_NAME: name of the database to backup
  • BACKUP_FREQ: How often to do a dump, in minutes. Defaults to 60 minutes, or once per hour.
  • B2_APPLICATION_KEY_ID: b2 account id
  • B2_APPLICATION_KEY: b2 application key
  • B2_BUCKET: b2 bucket to use
  • B2_TARGET_DIR: b2 target prefix e.g. backups

Usage

docker run -d \
-e BACKUP_DB_HOST='mysql01.domain.tld' \
-e BACKUP_DB_USER='mydbuser' \
-e BACKUP_DB_PASSWORD='mysecretpassword' \
-e BACKUP_DB_NAME='mydatabase' \
-e BACKUP_FREQ=60 \
-e B2_APPLICATION_KEY_ID='myb2accountid' \
-e B2_APPLICATION_KEY='myb2applicationkey' \
-e B2_BUCKET='my_b2_bucket' \
-e B2_TARGET_DIR='mysql01-backup' \
danstreeter/docker-mysql-b2

Credits