定期备份mysql的log日志文件，保留一个月

将文件压缩为gzip格式，节省空间，备份到/home/shell/myqsl_back/目录下，保留一个月

mysql_backup备份的脚本       

#!/bin/bash

/usr/local/mysql/bin/mysqldump -uroot -pmingqua1 --all-databases --routines --events --triggers | gzip > /home/shell/mysql_bakup/mysql_bakup_`date '+%Y-%m-%d'`.sql.gz

find /home/shell/mysql_bakup -mtime +30 -name "*.gz" -exec rm -rf {} \;

 

 

 

定期处理nginx的log文件

#!/bin/bash

#function:cut nginx log files

#

#set the path to nginx log files

log_files_path="/home/wwwlogs/"

#log_files_dir=${log_files_path}$(date -d "yesterday" +"%Y")/$(date -d "yesterday" +"%m")

log_files_dir=$(date -d "yesterday" +"%Y")/$(date -d "yesterday" +"%m")

#set nginx log files you want to cut

log_files_name=( ggg8.com_access,xxx.com_access,别的省略)   

#这是从/usr/local/nginx/conf/vhost/ggg8.com.conf  xxx.com.conf

#set the path to nginx.

nginx_sbin="/usr/local/nginx/sbin/nginx"

#Set how long you want to save

save_days=30

cd $log_files_path

############################################

#Please do not modify the following script #

############################################

mkdir -p $log_files_dir

log_files_num=${#log_files_name[@]}

#cut nginx log files

for((i=0;i<$log_files_num;i++));do

#mv ${log_files_path}${log_files_name[i]}.log ${log_files_dir}/${log_files_name[i]}_$(date -d "yesterday" +"%Y%m%d").log

tar -zcvf ${log_files_dir}/${log_files_name[i]}_$(date -d "yesterday" +"%Y%m%d").tar.gz ${log_files_name[i]}.log

#delete source

rm -rf ${log_files_name[i]}.log

done

#delete 30 days ago nginx log files

find $log_files_path -mtime +$save_days -exec rm -rf {} \;

$nginx_sbin -s reload

还有一个nginx定期处理脚本文件：

#!/bin/bash

#desc:把当前日志按日期备份，重新生成第二天的日志文件

DATE=`date +%Y%m%d`

NGINX_PID=`cat /var/run/nginx.pid`

#如果当前Nginx没有运行就退出

if [ "$?" != 0 ]

then

        exit 1;

fi

#nginx 日志所在的路径

LOG_PATH='/usr/local/nginx/logs/'

LOG_NAME='access.log'

mv ${LOG_PATH}${LOG_NAME} ${LOG_PATH}${LOG_NAME}$DATE

#删除7天前旧的备份文件

function deloldbak()

{

        olddate=`date +"%Y%m%d" -d "-$1 day"`

        if [ -e "${LOG_PATH}${LOG_NAME}$olddate" ]

        then

                rm -f ${LOG_PATH}${LOG_NAME}$olddate

                echo "${LOG_PATH}${LOG_NAME}$olddate del OK"

        fi

}

#重载nginx配置，重新生成nginx日志文件

kill -USR1 $NGINX_PID

if [ "$?" == 0 ]

then

        deloldbak 7

        exit 0;

fi

data -d +"%Y-%m-%d"

date -d "yesterday" +"%Y"

date -d "yesterday" +"%m"

[root@test2 ~]# date +"%Y-%m-%d"

2018-03-28

[root@test2 ~]# date -d "yesterday" +"%m"

03

[root@test2 ~]# date -d "yesterday" +"%d"

27

[root@test2 ~]# date -d "1 day ago" +"%Y-%m-%d"

2018-03-27

[root@z ~]# date -d "yesterday" +"%Y"

2018

 

 

crontab -e

mkdir -p /home/shell/

* 0 * * * sh /home/shell/cut_nginx_logs.sh  >> /dev/null 2>&1        

0 3 * * * sh /home/shell/mysql_bakup.sh >> /dev/null 2>&1