amazon-site-backup.sh

#!/bin/sh

SITE="site"
SITEDB="site_db"
SITEUSER="sitedbuser"
SITEDBPW="sitedbpass"
TRACKDB="jiradbuser"
TRACKUSER="jiradbuser"
TRACKDBPW="jiradbpass"
THEDATE=`date +%d%m%y%H%M`


# export forum database
mysqldump -u $SITEUSER -p${SITEDBPW} $SITEDB | gzip >
/var/www/backup/dbbackup_${SITEDB}_${THEDATE}.bak.gz

# export forum database
mysqldump -u $TRACKUSER -p${TRACKDBPW} $TRACKDB | gzip >
/var/www/backup/dbbackup_${TRACKDB}_${THEDATE}.bak.gz

# export files
tar czf /var/www/backup/sitebackup_${THESITE}_${THEDATE}.tar -C /
var/www/mysite

tar cvf nginx${THEDATE}.tar /etc/nginx

# remove backups older than 5 days
find /var/www/backup/site* -mtime +5 -exec rm {} \;
find /var/www/backup/db* -mtime +5 -exec rm {} \;

# sync to amazon
/usr/local/bin/aws s3 sync /var/www/backup s3://mysite --delete