数据库增量备份: 建目录:/usr/local/mysql/log/ 可读可写可执行!! 开启以下: [mysqld] log-bin=/usr/local/mysql/log/mysql-bin.log #日志保存7天后自动删除 expire_logs_day=7 以root用户,添加和执行crontab定时任务: #花卉宝 每周执行脚本 #0 1 * * 0 /opt/shell/week.sh 1>> /opt/shell/log/week_info_$(date +\%Y\%m\%d).txt 2>> /opt/shell/log/week_err_$(date +\%Y\%m\%d).txt #花卉宝 每天执行脚本 #0 1 * * * /opt/shell/day.sh 1>> /opt/shell/log/day_info_$(date +\%Y\%m\%d).txt 2>> /opt/shell/log/day_err_$(date +\%Y\%m\%d).txt