#!/bin/bash
#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
# $Id$
#------------------------------------------------------------
# backup wiki and fogbugz

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

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

BACKTHISUP=1

echo `date` "-- Started DB dump for $DATE"
for DB in fogbugz phpwiki rs_wordpress
do
    echo `date` "-- Backing up $DB"
    cd $MYSQLDIR
    mysqlhotcopy $DB $BACKDIR

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

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

    rm -rf $DB
done

 cd /var/www/html/wiki/wiki.d/
 tar cvzf $BACKDIR/wikifolder.$DATE.tgz *
 chown wwwadmin.wwwadmin  /backup/dbdumps/*
 rsync -avzP /backup/dbdumps/ administrator@cm01:/cygdrive/i/backup/tools/dbdumps/
 scp /var/named/royaltyshare.zone administrator@cm01:/cygdrive/i/backup/tools/
 rm -f /backup/dbdumps/*

exit