[ILUG] MySQL binlog rotation on Debian Etch

[John McCormac]

Stephen Burke wrote:
> 
> On Tue, 1 Apr 2008, Ciaran Johnston wrote:
> 
>> I have:
>> log_bin                        = /var/log/mysql/mysql-bin.log
>> expire_logs_days       = 7
>> max_binlog_size         = 100M
>>
>> The config from a default install looks something like this
>> (taken from an Ubuntu machine but identical to the Etch ver. AFAIR):
> 
> 
> No joy. Old bin logs are still been left in /var/log/mysql/ and not 
> removed after 7 days.
> 
> Any other suggestions as to the best method? I'll probably just use 
> logrotate, if I dont get any better suggestions.

Run something like this in a procedure or as a cronjob.

purge binary logs before '2008-mm-dd hh:mm:ss';

Regards...jmcc
-- 
******************************************************
John McCormac  *  e-mail: jmcc at whoisireland.com
MC2            *  voice:  +353-51-873640
22 Viewmount   *  web:  http://www.whoisireland.com/
Waterford      *  blog: http://blog.whoisireland.com
Ireland        *  Irish Domain Stats & Market Research
******************************************************