MySQL自动备份shell脚本

#!/bin/sh

#function:mysql database backup
#author:reed
#date:2015-02-26

. /etc/profile

DB_NAME=cloudbridge
DB_USER=cloud
DB_PASSWD=cloud
BAK_DIR=/root/BAK_DIR
BAK_FILE=$DB_NAME-`date +%F`.sql

#mkdir bakcup dir
[ ! -d $BAK_DIR ] && mkdir -p $BAK_DIR

FUNC()
{
        echo "[INFO][`date +%F_%T`]Begin to backup."
        echo "[INFO][`date +%F_%T`]cd $BAK_DIR"
        cd $BAK_DIR
        echo "[INFO][`date +%F_%T`]mysqldump -u$DB_USER -p$DB_PASSWD $DB_NAME >> $BAK_FILE"
        echo "[INFO][`date +%F_%T`]Please wait..."
        mysqldump -u$DB_USER -p$DB_PASSWD $DB_NAME >> $BAK_FILE
        if [ $? -eq 0 ];then
                echo "[INFO][`date +%F_%T`]tar -zcvf $BAK_FILE.tar.gz $BAK_FILE"
                tar -zcvf $BAK_FILE.tar.gz $BAK_FILE
                echo "[INFO][`date +%F_%T`]rm -rf $BAK_FILE"
                rm -rf $BAK_FILE
                echo "[INFO][`date +%F_%T`]Backup database $DB_NAME successfully."
        else
                echo "[INFO][`date +%F_%T`]Backup database $DB_NAME falied.Please check it!"
                exit 111
        fi

}
FUNC >> $BAK_DIR/baklog_$(date +%F_%T).log