backup script'i

#!/bin/sh

BACKSDIR="/var/backup/mysql_sql"

rm -f ${BACKSDIR}/*
mkdir -p ${BACKSDIR}

for i in `/usr/local/bin/mysql -uroot -p sifre -B -N -e 'show databases;'`
do
/usr/local/bin/mysqldump -uroot -p sifre -f -Q -r "${BACKSDIR}/${i}.sql" ${i}
done

DATE=`/bin/date "+%d-%m-%Y"`
tar ycf /var/backup/mysql/${DATE}-mysql.tar.bz2 -C "${BACKSDIR}" .