mysql_backup_rsync

#!/bin/bash

RSYNC="/usr/bin/rsync"
DAY=`/bin/date "+%u_%A"`
MYSQLDUMP="/usr/bin/mysqldump"
DBDIR=`ls /www/mysql/`
BACKUPDIR="/www/backup/week/$DAY"
DBPASS="secret"

test -d $BACKUPDIR || mkdir $BACKUPDIR

for i in $DBDIR; do
    if [ -d /www/mysql/$i ]; then
        $MYSQLDUMP --all --single-transaction --add-drop-table --comments=false 
          --extended-insert -u root -p$DBPASS $i > $BACKUPDIR/$i.sql
    fi
done

cd $BACKUPDIR
rm *.gz
tar cfz db.$DAY.tar.gz *.sql
rm *.sql
tar cfvz cesar.$DAY.tar.gz /www/cesar2/*