#!/bin/bash

# Configuration
CONTAINER="mysql"
FILENAME="databasename-`date +%Y-%m-%d`.sql"
MYSQL_USER='user'
MYSQL_PASSWORD='password'
DATABASE_NAME='databasename'
S3_BUCKET_NAME='bucket'
S3_BUCKET_PATH='backups'

# Backup from Docker
docker exec -it $(docker ps -f name=$CONTAINER -q --no-trunc | head -n1) mysqldump -u$MYSQL_USER -p$MYSQL_PASSWORD $DATABASE_NAME > /tmp/$FILENAME

# Upload to Digital Ocean Spaces
# s3cmd should be configured before
s3cmd put /tmp/$FILENAME s3://$S3_BUCKET_NAME/$S3_BUCKET_PATH/$FILENAME