MySQL自动备份脚本

#!/bin/bash
#by azura
#About database backup
#URL https://www.mxsina.com
DBCMD=/usr/local/mysql/bin/mysqldump #请修改为数据库dump命令目录
DBUSER=root
DBPWD=123456789                      #数字段请修改为root用户数据库连接密码
DATABASE=emlogdb                     #emlogdb请修改为备份的数据库
BAK_DIR=/mysqlbak/`date +%Y%m%d`     #/mysqlbak/目录可自由修改
 
if [ ! -d $BAK_DIR ];then
         mkdir -p $BAK_DIR
fi
 
if [ $UID -ne 0 ];then
         echo"Please use the root user to execute"
         exit
fi
echo "-------------------------------------------------------------------------------------------------"
echo
echo "Start the database backup"
#示例备份命令mysqldump -uroot -p123456789 emlogdb > /mysqlbak/bak_emlogdb.sql
$DBCMD -u$DBUSER -p$DBPWD $DATABASE > $BAK_DIR/db_emlog.sql    #db_emlog.sql可修改为备份文件的文件名
if [ $? -eq 0 ];then
 
              echo -e "\033[32mBackup Success !\033[0m"
else
              echo "Backup Fail"
fi
 
find $BAK_DIR -mtime +30 -exec rm -rf {} \;  #此处数字可修改表示删除30前的数据
 
#蔚然博客Azura编写