Cron script: MySQL Nightly Backups to S3

mysql-backup-to-s3

#!/bin/bash

# /etc/cron.daily/mysql-s3-backup

# Before use, install AWS CLI and use "aws configure" to set up credentials with write access to your s3 bucket
# See https://docs.aws.amazon.com/cli/latest/userguide/install-cliv2-linux.html#cliv2-linux-install

DB_USER=XXX
DB_NAME=XXX
DB_PASS=XXX
BUCKET_NAME=XXX

BACKUP_FILENAME=$DB_NAME-$(date +%Y-%m-%dT%H:%M:%S).sql.gz

mysqldump $DB_NAME -u $DB_USER -p$DB_PASS | gzip > $BACKUP_FILENAME
aws s3 cp $BACKUP_FILENAME s3://$BUCKET_NAME
rm $BACKUP_FILENAME