#!/bin/sh

DB_USER="mysql_user_name"
DB_PASS="mysql_password"
BK_DIR="/backup_dir"
MYSQL_PATH="/usr/local/mysql/bin"

DATE=`date +%F`
DIR="$BK_DIR/$DATE"
if [ ! -d "$DIR" ];then
    mkdir $DIR
fi

BKFILE="$BK_DIR/$DATE.tar.gz"

$MYSQL_PATH/mysql -u$DB_USER -p$DB_PASS  <<< 'show databases' | while read i
do
    a=`echo $i | grep 'Database'`
    if [ -z "$a" ]
    then
        TMP_FILE="$DIR/$i.sql"
        $MYSQL_PATH/mysqldump --opt -u$DB_USER -p$DB_PASS $i > $TMP_FILE
    fi
done

tar cvzf $BKFILE $DIR
rm -rf $DIR