How to use logrotate to manage binary logs
Hi all, This may be a simple solution that I'm just not seeing. logrotate has trouble with binlogs since the extension keeps changing, so instead of actually rotating logs out, I just get a dir filled with binlog.001.1 binlog.002.1 binlog.003.1 binlog.004.1 binlog.005.1 binlog.006.1 and on to inifinity. The manual says If you supply an extension in the log name (for example, |--log-bin=/|file_name.extension|/|), the extension is silently removed and ignored, so it appears I'm stuck. Does anyone have some pointer for me to set up auto-rotation? I'm somehow not finding much info on this. kgt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to use logrotate to manage binary logs
Kristen G. Thorson wrote: Hi all, This may be a simple solution that I'm just not seeing. logrotate has trouble with binlogs since the extension keeps changing, so instead of actually rotating logs out, I just get a dir filled with binlog.001.1 binlog.002.1 binlog.003.1 binlog.004.1 binlog.005.1 binlog.006.1 and on to inifinity. The manual says If you supply an extension in the log name (for example, |--log-bin=/|file_name.extension|/|), the extension is silently removed and ignored, so it appears I'm stuck. Does anyone have some pointer for me to set up auto-rotation? I'm somehow not finding much info on this. kgt Don't do that. You will break replication. Set up a cron job to flush logs instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]