#!/bin/bash
#
# description:  Simple backup-Script for Rock-Spot.de
#               Includes:
#                       - Full database backup (table based)
#                       - Full web directory
#                       - Full /etc/ directory (all system configuration)
#                       - Copying compressed backups to external FTP
#
# @author:      Alexander Hagenah <ah@primepage.de>
# @created:     08/13/2009

# VARIABLES
BACKUPDIR="/home/backup"
FTP_HOST="xxx"
FTP_USER="xxx"
FTP_PASS="xxx"
FTP_DIR="backup/"
NCFTP="/usr/bin/ncftpput"
#MAILC="/usr/bin/sendmail"
#MFILE="/tmp/ftpout.$$.txt"
#MESS=""

cd $BACKUPDIR

# MySQL Backup
mk-parallel-dump --user root --password xxx --flushlock --setperdb --basedir $BACKUPDIR/db/

# All Files
rsync -az /var/www/ $BACKUPDIR/web/
rsync -az /etc/ $BACKUPDIR/configs/

tar cfj mysql.tar.bz2 db/
tar cfj configs.tar.bz2 configs/

# $NCFTP -m -u "$FTP_USER" -p "$FTP_PASS" "$FTP_HOST" "$FTP_DIR" mysql.tar.bz2
# $NCFTP -m -u "$FTP_USER" -p "$FTP_PASS" "$FTP_HOST" "$FTP_DIR" configs.tar.bz2