每天00:00将mysql日志上传到日志服务器,并清空服务器日志
1.创建日志上传脚本
#collect_log.sh directory is /home/admin/auto_shell
fileName=$(date '+%Y-%m-%d)
tar -czvf $fileName.tar.gz /var/log/mysql
ftp -nv <<!
open x.x.x.x //ftpServerIp
user USERNAME PASSWORD
lcd var/log
put $fileName.tar.gz
quit
cd /var/log/mysql &&rm -rf *
2.crontab配置
su
crontab -e
0 0 * * * cd /home/admin/auto_shell &&./collect_log.sh