Hi,
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!
Regards,
Nitin
