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 { rotate 5

Rotating mysqld.log

2002-06-10 Thread Ramasubramanian
Hi All, I have a RH-7.2 server running mysql 3.23.41-1. I need to rotate the mysqld.log based on some size criteria. I have a config file as follows : mysqlrotparams.conf *** /var/log/mysqld.log { rotate 5

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

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