backup.sh

# dump database and files 
mysqldump -u user database > ~/database.sql
tar -zcvf ~/backup.tar.gz database.sql /var/www/sitefolder
rm ~/database.sql

remote-backup.sh

# do backup of the remote server
PEM=x.pem
SSH="[email protected]"
MYSQL_USER="user"
MYSQL_DATABASE="database"
SITE_FOLDER="/var/www/default"
BACKUP_NAME="domain.com.tar.gz"

ssh -i $PEM $SSH -t "mysqldump -u ${MYSQL_USER} ${MYSQL_DATABASE} > ~/database.sql; tar -zcvf ~/backup.tar.gz database.sql ${SITE_FOLDER} ; rm ~/database.sql"
rsync -avz -e "ssh -i ${PEM}" $SSH:~/backup.tar.gz $BACKUP_NAME

# download file variants
# rsync -chavzP --stats [email protected]:~/backup.tar.gz backupsite.tar.gz
# rsync -avz -e "ssh -i cert.pem" [email protected]:~/backup.tar.gz backupsite.tar.gz