> From: Ramasubramanian [mailto:[EMAIL PROTECTED]]
> Hi,
> I tried to flush the logs but still the rotation doesn't happen.
> What else could be the problem ??
> I get the same message again
> My config file read like this
> "/var/log/mysqld.log" {
> ro
Hi,
I tried to flush the logs but still the rotation doesn't happen.
What else could be the problem ??
I get the same message again
My config file read like this
"/var/log/mysqld.log" {
rotate 5
size=100k
create 0
You need to get logrotate to flush-logs otherwise mysql will still write to
the old file.
eg add after the create 0644 mysql mysql line:
postrotate
if test -n "`ps acx | grep mysql`";then
/path/to/mysqladmin -u logflusher -ppassword flush-logs
fi
endscript
Assuming a mysql users called