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

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

BACKDIR="/app/backup/snapshots"
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" | grep '^RSCOMMON$\|^C_'`
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  /app/backup/snapshots/*
done

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