RE: Rotating mysqld.log

2002-06-11 Thread Greg_Cope
> 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

RE: Rotating mysqld.log

2002-06-10 Thread Ramasubramanian
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

RE: Rotating mysqld.log

2002-06-10 Thread Greg_Cope
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