#!/bin/bash
DB_BACKUP="/backup/db/daily"
MYSQL="/usr/bin/mysql"

databases=`$MYSQL -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
for db in $databases; do
    echo $db
    mysqldump -uroot $db > "$DB_BACKUP/$db-`date +%d-%b-%Y`.sql"
        cd $DB_BACKUP/
        tar -cf - $db-`date +%d-%b-%Y`.sql | gzip > $db-`date +%d-%b-%Y`.sql.tgz
        rm -f $db-`date +%d-%b-%Y`.sql
done