On Saturday 05 April 2008 16:19:17 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.
The /etc/logrotate.d/mysql-server script runs:
/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf flush-logs
daily. The debian.cnf file includes a debian-sys-maint user and password,
which may differ from what's in your database if, for example, you restored
your databases from a different box. You might try checking those settings,
or running the mysqladmin command manually to see if it's working.
/Ciaran.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
