1.创建文件夹
mkdir -p /home/mysql_backup/
touch /home/mysql_backup/mysql_backup.sh
chmod 777 /home/mysql_backup/mysql_backup.sh
2.编辑/home/mysql_backup/mysql_backup.sh
vim /home/mysql_backup/mysql_backup.sh
写入内容:
BKDIR=/home/mysql_backup
time=`date +%Y_%m_%d_%H_%M_%S`
echo "dump sql to ${BKDIR} ${time}"
mysqldump --all-databases | gzip > $BKDIR/$time.sql.gz
find $BKDIR -name "*.sql.gz" -type f -mtime +5 -exec rm -rf {} \; > /dev/null 2>&1
3.编辑crontab
crontab -e
在最后一行加入
#每天凌晨备份,并且输出日志
0 0 * * * /home/mysql_backup/mysql_backup.sh >> /home/mysql_backup/backup.log
4.重启crontab
service crond restart
5.配置mysql文件
vim /etc/my.cnf
加入,注意密码有单引号
[mysqldump]
user=root
host=127.0.0.1
password='123456'