1、新建mysql的备份目录mkdir -p path/mysql/backup/
2、新建备份脚本vi path/mysql/backup/backup.sh
#!/bin/bash
backupdir=path/mysql/backup/
time=` date +%Y%m%d `
db_user=root
db_pass=***
db=demo
path/mysql/bin/mysqldump -u $db_user -p$db_pass -S path/mysql/mysql.sock --databases $db | gzip > $backupdir/demo$time.sql.gz
find $backupdir -name "*.gz" -type f -mtime +180 -exec rm -rf {} \; > /dev/null 2>&1
3、添加脚本的可执行权限chmod 755 path/mysql/backup/backup.shcrontab -e
#每月8号10点30分执行一次
30 10 8 * * path/mysql/backup/backup.sh
service crond restart