[Linux] 利用logrotate对MySQL日志进行轮转(二)
ain]
[mysqladmin]
password = ***
user= root
chmod 600 /root/.my.cnf
2）把mysql-log-rotate拷贝至/etc/logrotate.d目录下，修改其内容为：
[plain]
/data/mysql/log/slow.log
/data/mysql/log/alert.log {
create 600 mysql mysql
notifempty
daily
rotate 7
missingok
# compress
# just if mysqld is really running
if test -x /opt/mysql/bin/mysqladmin && \
/opt/mysql/bin/mysqladmin ping &>/dev/null
then
/opt/mysql/bin/mysqladmin flush-logs
fi
endscript
}
3）执行以下命令测试
[plain]
/usr/sbin/logrotate -f /etc/logrotate.d/mysql-log-rotate