linux中mysql数据库备份脚本

#!/bin/bash
#auto backup mysql db
#by authors wyf 2016
#define backup path
BAK_DIR=/data/backup/`date +%Y%m%d`
#echo $BAK_DIR
MYSQL_DB=mycourse
MYSQL_USER=wyfdb
MYSQL_PWD=123456
MYSQL_CMD=mysqldump
#需要root用户执行
if [ $UID -ne 0 ] ; then
        echo "Must to be use root fro exec Shell."
        exit
fi
#判断文件路径是否存在，不存在则创建
if [ ! -d $BAK_DIR ] ; then
        mkdir -p $BAK_DIR
        echo  "The $BAK_DIR Create Successful!"
else
        echo "This $BAK_DIR is exists."
fi

#执行数据库备份脚本导出
/usr/bin/$MYSQL_CMD -u$MYSQL_USER -p$MYSQL_PWD  $MYSQL_DB >$BAK_DIR/$MYSQL_DB.sql
#上一命令执行成功
if [ $? -eq 0 ] ; then
        echo  "The $MYSQL_DB Create Successful!"
else
        echo  "The $MYSQL_DB Create Failed. Please check!"