CentOS6上的cron命令
service crond start //启动服务
service crond stop //关闭服务
service crond restart //重启服务
service crond reload //重新载入配置
service crond status //查看状态
CentOS7上的cron命令
systemctl start crond.service //启动服务
systemctl stop crond.service //关闭服务
systemctl restart crond.service //重启服务
systemctl reload crond.service //重新载入配置
systemctl status crond.service //查看状态
tail -f -n 200 /var/log/cron //查看定时任务日志
脚本存放位置:/home/mysql-backup.sh
定时任务脚本生成地址:/usr/local/data/mysqlbak/
chmod 777 mysql-backup.sh //修改sh的权限
crontab -e //编辑定时任务 增加定时任务
0 1 * * * /home/mysql-backup.sh //每天凌晨1点执行此文件
mysql-backup.sh数据库脚本文件
database=yd_cdxcds
username=root
backupDir=/usr/local/data/mysqlbak
backupTime=`date +%Y%m%d%H%M%S`
mysqldump -u$username $database | gzip > $backupDir/$database-$backupTime.sql.gz
echo "$database-$backupTime备份完成" >> $backupDir/mysql-backup.log
cd $backupDir
rm -rf `find . -name '*.sql.gz' -mtime +30`
echo "删除30天前的备份文件完成" >> $backupDir/mysql-backup.log