#!/bin/sh

# db details
DBHOST='localhost'
DBPORT='3306'
DBUSER='root'
DBPASS='password'
DBNAME='databasename'
# s3 details
S3BUCKET='bucketname'
S3PATH='path/in/bucket'
TMPDIR='/tmp/s3'
# variables
CURRDATE=$(date +%Y-%m-%d)
PREVDATE=$(date +%Y-%m-%d --date='4 week ago')


### SCRIPT STARTS ###

# make the tmp dir
mkdir -pv $TMPDIR
cd $TMPDIR

# dump db and backup to s3
mysqldump -h$DBHOST -P$DBPORT -u$DBUSER -p$DBPASS --quote-names --create-options --force $DBNAME > $DBNAME.$CURRDATE.sql
gzip $DBNAME.$CURRDATE.sql
aws s3 cp $TMPDIR/$DBNAME.$CURRDATE.sql.gz s3://$S3BUCKET/$S3PATH/
aws s3 rm s3://$S3BUCKET/$S3PATH/$DBNAME.$PREVDATE.sql.gz

# remove files in tmp dir
cd
rm -rfv $TMPDIR/*