#!/bin/bash
#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
# $Id$
#------------------------------------------------------------
#
# back up all of the databases
#
#

DATE=`date '+%G%m%d'`

BACKDIR="/backup/dbdumps"
MYSQLDIR="/var/lib/mysql"


BACKTHISUP=1
cd $MYSQLDIR

echo `date` "-- Started DB dump for $DATE"
#for DB in `/usr/bin/mysql -uroot -e "show databases"` 
for DB in fogbugz phpwiki rs_wordpress
do
    echo `date` "-- Backing up $DB"
    mysqlhotcopy $DB $BACKDIR

    if [ "0" != $? ];
    then
        echo "mysqlhotcopy returned an error, skipping $DB"
        continue
    fi

    echo `date` "-- Gzipping $DB"
    tar cvzf $BACKDIR/$DB.$DATE.tgz $BACKDIR/$DB/*

    rm -rf $BACKDIR/$DB
    chown wwwadmin.wwwadmin  /backup/dbdumps/*
done

echo `date` "-- Finished DB dump for $DATE"