简单数据库备份脚本

备份MySQL数据库的脚本
#!/bin/bash
#auto if test1
#by authors liujie 0727
#define backup path
BAK_DIR=/data/backup/`date +%Y%m%d`
MYSQLDB=discuz
MYSQLUSE=backup
MYSQLPW=123456
MYSQLCMD=/usr/bin/mysqldump
if [ $VIU -ne 0 ];then
echo "Must to be use root for exec shell"
exit
fi

if [ !-d $BAK_DIR ];then
mkdir -p $BAK_DIR
echo "\033[32mThe $BAK_DIR create successfully!\033[0m"
else
echo "This $BAK_DIR is exists......"
fi
#Mysql BACKUP COMMAND
$MYSQLCMD -u$MYSQLVSR -p%MYSQLPW -d$MYSQLDB >$BAK_DIR/$MYSQLDB.sql
if [ $? -eq 0 ];then
echo "\033[32mThe Mysql Backup $MYSQLDB Successfully!\033[0m"
else
echo "\033[32mThe Mysql Backup $MYSQLDB Failed,Please check.!\033[0m"
fi

每天需要运行此脚本的话
# crontab -e
0 0 * * * /bin/bash /data/shell/auto_backup_mysql.sh >> /tmp/mysql_bak.log 2>$1