- 数据库增量备份:
- 建目录:/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
|