#!/bin/sh

#
# backup sql databases and save to subversion
#

THEHOST=$(echo "$HOSTNAME" | cut -d. -f 1)

cd ~/sql-backup/

mkdir -p $THEHOST
svn add $THEHOST 2>&1 | grep -v 'already under version control$'
cd $THEHOST

MYSQLDUMP_FLAGS="--add-drop-table --add-locks --all --quick --lock-tables --quote-names"

echo 'show databases;' | mysql -u backup -p******** | tail +2 | \
while read database ; do
	mysqldump -u backup -p******** $MYSQLDUMP_FLAGS "$database" > "$database.sql"
done

svn add *.sql 2>&1 | grep -v 'already under version control$'
cd ..

svn ci -m "Scripted backup of MySQL databases on $THEHOST." $THEHOST
svn up