#!/bin/bash
#LINUX下数据库审计日志按日分割的shell
#设置你的日志存放的目录
log_files_path="/opt/audit-mysql-log/"
#日志以年/月的目录形式存放
#log_files_dir=${log_files_path}$(date -d "yesterday" +"%Y")/$(date -d "yesterday" +"%m")
log_files_dir=${log_files_path}$(date -d "yesterday" +"%Y")-$(date -d "yesterday" +"%m")
#设置需要进行日志分割的日志文件名称,多个以空格隔开
log_files_name=(3306)
#Set how long you want to save
save_days=30
############################################
#Please do not modify the following script #
############################################
mkdir -p $log_files_dir
log_files_num=${#log_files_name[@]}
#cut audit-mysql-log 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%T").log
done
#delete 30 days ago nginx log files
#find $log_files_path -mtime +$save_days -exec rm -rf {} \;