My Ubuntu web server rsync backup scripts

backup.sh

#!/bin/sh

user="mysqluser"
pass="mysqlpass"
dir="/tmp/backup"

for i in /var/lib/mysql/*/; do
  dbname=`basename $i`
  if [ $dbname != "mysql" ]; then
    mysqldump -u$user -p$pass $dbname > $dir/db/$dbname.sql
  fi
done

rsync -a --delete /etc/apache2/sites-available $dir
rsync -a --delete --exclude-from '/tmp/backup/exclude.txt' /srv $dir

exclude.txt

/srv/www/*/logs/*
/srv/www/*/log/*

fetch_backup.sh

#!/bin/sh

host="user@domain.com"
sourcedir="/tmp/backup"
destdir="/backups"

rsync -avz --delete --progress $host:$sourcedir $destdir