> -Original Message-
> From: Pete Harlan [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 27, 2007 5:15 PM
> To: Tim Lucia
> Cc: mysql@lists.mysql.com
> Subject: Re: My bin.log directory is getting full
>
> Perhaps the "expire_logs_days" variable doe
Perhaps the "expire_logs_days" variable does what you're looking for.
--Pete
On Thu, Apr 26, 2007 at 09:01:58PM -0400, Tim Lucia wrote:
> # cat /etc/cron.mysql/20-purgemasterlogs
> #!/bin/sh
> /usr/bin/mysql --defaults-file=/root/.my.cnf -e 'show master logs; purge
> master logs before date_sub(n
# cat /etc/cron.mysql/20-purgemasterlogs
#!/bin/sh
/usr/bin/mysql --defaults-file=/root/.my.cnf -e 'show master logs; purge
master logs before date_sub(now(), interval 30 day); show master logs;'
>/var/log/20-purgemasterlogs.log 2>&1
This purges anything older than 30 days.
HTH,
Tim
> -Origi
Hello,
Brown, Charles wrote:
Hello All. My bin.log directory is getting full with bin.log files. We
are running out of space. What can I do in the short term? Is there a
command that I can issue that will get rid of old bin log files not
needed?
In the short term, see the manual page for PURGE
