#!/bin/bash

BACKUPDIR="/home/backups"

SYSBACKUPDIR="${BACKUPDIR}/files"

MYSQLUSER="root"
MYSQLPASS="change_me"
MYSQL_OUTDIR="${BACKUPDIR}/mysql"

FTPUSER="backup"
FTPPASS="password"
FTPSERVER="backup.dc.volia.com"

PATH=PATH:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin

#BACKUP DPKG
dpkg --get-selections > $BACKUPDIR/dpkg-selections.txt

#BACKUP MYSQL
if [ ! -d $MYSQL_OUTDIR ]; then
    mkdir -p $MYSQL_OUTDIR
fi

cd /var/lib/mysql
for i in * ; do
    if [ -d $i ]; then
        mysqldump --user=$MYSQLUSER --password=$MYSQLPASS --opt --add-drop-table -q -Q -e $i > $MYSQL_OUTDIR/$i.sql
        bzip2 --best -f $MYSQL_OUTDIR/$i.sql
    fi
done

#BACKUP SYSTEM
rdiff-backup --remove-older-than 20D $SYSBACKUPDIR

rdiff-backup --exclude $BACKUPDIR \
    --exclude /home/andrew \
    --exclude '**.log' \
    --include /var/spool/cron/crontabs \
    --include /var/backups \
    --include /etc \
    --include /root \
    --include /var/www \
    --include /home \
    --include /usr/local \
    --include /var/lib/dpkg/status \
    --include /var/lib/dpkg/status-old \
    --exclude '/*' \
    / $SYSBACKUPDIR

#TAR ALL THE STUFF
tar -c $BACKUPDIR/files > $BACKUPDIR/files.tar


cd $BACKUPDIR
for i in * ; do
    if [ "$i" != "files" ]; then
        wput --remove-source-files --dont-continue --reupload --quiet $i ftp://$FTPUSER:$FTPPASS@$FTPSERVER/
    fi
done