#!/bin/bash
BUCKET=bucketname
MYSQL_USER=username MYSQL_PASSWORD=password MYSQL_HOST=localhost
echo 'Started'
date +'%a %b %e %H:%M:%S %Z %Y'
mysqldump -u $MYSQL_USER -p$MYSQL_PASSWORD --single-transaction --routines --triggers --all-databases | gzip > backup.gz
S3_KEY=$BUCKET/database/$(date "+%Y-%m-%d")-backup.gz /root/.local/bin/aws s3 cp backup.gz s3://$S3_KEY
rm -f backup.gz date +'%a %b %e %H:%M:%S %Z %Y' echo 'Finished'
