mc388/mysql-dropbox-backup repository overview

⁠mysql-dropbox-backup

Backup MySQL to Dropbox

⁠Basic Usage

$ docker run \
  --name mysql_backup \
  -d \
  --restart=always \
  --log-opt max-size=1m \
  --log-opt max-file=5 \
  -e MYSQL_DATABASE=anydb \
  -e MYSQL_USER=root \
  -e MYSQL_PASSWORD=root \
  -e MYSQL_HOST=mysql \
  -e DROPBOX_PREFIX=PROJECT_NAME \
  -e DROPBOX_ACCESS_TOKEN=YOUR_TOKEN \
  -e SCHEDULE=@daily \
  mc388/mysql-dropbox-backup

⁠Environment variables

• MYSQLDUMP_OPTIONS mysqldump options (default: --quote-names --quick --add-drop-table --add-locks --allow-keywords --disable-keys --extended-insert --single-transaction --create-options --comments --net_buffer_length=16384)
• MYSQL_HOST the mysql host required
• MYSQL_PORT the mysql port (default: 3306)
• MYSQL_DATABASE the mysql database required
• MYSQL_USER the mysql user required
• MYSQL_PASSWORD the mysql password required
• DROPBOX_PREFIX path prefix in your Dropbox (default: empty)
• DROPBOX_ACCESS_TOKEN your Dropbox API access token required
• SCHEDULE backup schedule time, see explainatons below

⁠Automatic Periodic Backups

You can additionally set the SCHEDULE environment variable like -e SCHEDULE="@daily" to run the backup automatically.

More information about the scheduling can be found here⁠.