#!/bin/sh

cd /

DEST=data/backup
SQL=tmp/dump-$$.sql
PKGS=tmp/pkglist-$$

SOURCE="home/ianc etc usr/local/etc usr/local/svn usr/local/svn-private $SQL $PKGS"

BACKUP=$DEST/$(date +%Y%m%d-%H%S).tar.gz

echo Dumping database
mysqldump -u root --password=$(cat /usr/local/etc/mysqlpassword) --all-databases > $SQL

echo Dump installed packages
/usr/local/bin/listinstalledpkgs.sh > $PKGS

echo Backing up to $BACKUP

tar cfz $BACKUP $SOURCE

rm -f $SQL

cd $DEST
echo Clearing old files
find . -mtime +10 -print -exec rm {} \;