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

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 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
done

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

exit