使用vim auto_backup_mysql.sh 在里面输入
#auto backup mysql db
#by authors dxw 2017
#dufine backup path
BAK_DIR=/data/backup/`date +%Y%m%d`
MYSQLDB=syuee
MYSQLUSR=syuee
MYSQLPW=123456
MYSQLCMD=/usr/bin/mysqldump
#判断是否为root用户
if [ $UID -ne 0 ]; then
echo "必须使用root用户执行。 "
exit
fi
#如果BAK_DIR这个目录不存在则创建,否则打印存在
if [ ! -d $BAK_DIR ];then
mkdir -p $BAK_DIR
echo -e "\033[32mThe $BAK_DIR Create Succsessfully!\033[0m"
else
echo -e "\033[32m This $BAK_DIR is exists...\033[0m"
fi
$MYSQLCMD -u$MYSQLUSR -p$MYSQLPW -d $MYSQLDB > $BAK_DIR/$MYSQLDB.sql
if [ $? -eq 0 ];then
echo -e "\033[32m The mysql backup $musqldb successfully !\033[0m"
else
echo -e "\033[32m the mysql backup $mysql_db Failedm please check.\033[0m"
fi
输入crontab -e 将执行脚本加入自动执行任务
0 0 * * * /bin/bash /data/shell/auto_backup_mysql.sh >>/tmp/mysql_bak.log 2>&1