#Setup Variables
DOMAIN=domainexample.com
FILENAME=${DOMAIN}.$(date +%Y%m%d)
DBSERVER=localhost
DATABASE=databasename
USER=mysqluser
PASS=mysqlpass
BACKUPSERVER=user@backupserverinfo:~
BACKUPSERVERPORT=22

# Dump Database for Backup
mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} > ${FILENAME}.sql

# GZIP the Database File
gzip -f ${FILENAME}.sql

# Make a TEMP DIR and Move the Backup to it for archival
mkdir /var/www/${DOMAIN}/db
cp $FILE.sql.gz /var/www/${DOMAIN}/db

# TAR & GZ herdinsider directory to preserve database, files and images
tar -czvf ~/${FILENAME}.website.tar.gz /var/www/${DOMAIN}

# Remove TEMP DB DIR and Backup
rm -rf /var/www/${DOMAIN}/db

# Transfer backups to backup server
scp -P ${BACKUPSERVERPORT} ${FILENAME}.sql.gz ${FILENAME}.website.tar.gz ${BACKUPSERVER}

# Clear out old backups
rm -rf ~/backups/*

# Move files to temp directory
mv ${FILENAME}.sql.gz ~/backups
mv ${FILENAME}.website.tar.gz ~/backups

# Completed Messages
echo Completed!