List:General Discussion« Previous MessageNext Message »
From:Nitin Mehta Date:August 10 2010 1:06pm
Subject:Help with flush logs
View as plain text  

This is probably very simple for someone who has encountered the problem before 
but I'm struggling to find how I can contain the MySQL error log from being 
flushed at "FLUSH LOGS" command. This command is executed as part of the 
database backup every night and simply moves the old error log to -old file. 
This way, I can only have maximum 2 days of error logs while I need to keep the 
logs for at least 60 days (for auditing as well as debugging purposes). I 
understand that I can probably achieve this using log rotate or similar things 
but just wondering if it is possible to achieve this within MySQL conf itself.

Thanks in advance!


Help with flush logsNitin Mehta10 Aug