配置crontab实现自动备份

crontab -e root* * 6 * * sh /data/backup/mysql_backup.sh >>/data/backup/backup.log 2>&1

#!/bin/bashDBusername=root         #数据库用户名DBpasswd=123             #数据库密码DBname=test                #数据库名Host=192.168.1.2         #ip地址，本地可用localhostPort=3306                     #数据库端口BKdir=/data/backup      #备份存放的目录 BKtime=`date +%Y%m%d`    #系统当前时间#开始备份mysqldump -h ${Host} -P${Port} -u${DBusername} -p${DBpasswd} ${DBname} \--default-character-set=utf8 --hex-blob -r ${BKdir}/${DBname}-${BKtime}.sql#截取所有备份文件的时间time1=`ls $BKdir/${DBname}*.sql |awk -F- '{print $2}'|awk -F. '{print $1}'`#删除30天以前的备份文件for time in ${time1}dotime2=$(($(date +%s) - $(date +%s -d ${time})));day=$((time2/60/60/24))if [[ ${day} > 30 ]]then    rm -f ${BKdir}/${DBname}-${time}.sqlfidone