#!/bin/bash

RHOST='user@hostname'
LPATH='/var/www/app-directory/'
DBPATH='/home/user/appbackup/app-name/db/'
SHAREPATH='/home/user/appbackup/app-name/shared/'

DBNAME='database_name'
DBUSER='database_user'
DBPASS='database_password'

# output a header for logging

echo ""
echo ""
echo "########################################"
echo "### BACKUP OF BACKUP_NAME $(date +%Y%m%d) ###"
echo "########################################"
echo ""

# backup database

mysqldump --opt --compress -u $DBUSER -p$DBPASS $DBNAME | ssh $RHOST "dd of=${DBPATH}${DBNAME}-$(date +%Y%m%d-%T).sql"

# clean up old db files

ssh $RHOST "find ${DBPATH} -mtime +120 -exec rm {} \;"

# rsync shared

rsync -avz -e ssh ${LPATH}shared/ $RHOST:$SHAREPATH

ssh $RHOST "touch ${SHAREPATH}sync-stamp.txt"