I've made a simple perl script that uses the 

show master logs 

and

purge master logs to 'mysql.???'

queries to remove all but the last seven logs and it works perfectly for me.

Check http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html for details.

-- 
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/


On Thursday 10 June 2004 10:05, Søren Neigaard wrote:
> Hi
>
> I have a MySQL (mysql-standard-4.0.17-pc-linux-i686) running as master
> where I have attached a slave to for replication. The problem now is that
> on the master there is a LOT of mysql-bin.XXX files, and they each take 1GB
> diskplace.
>
> Are these files needed still, or can i delete the old ones?
>
> Can I get MySQL to cleanup these files automatically?
>
> Med venlig hilsen/Best regards
> Søren Neigaard
> System Architect
> ................................
> Mobilethink A/S
> Arosgaarden
> Åboulevarden 23, 4.sal
> DK - 8000 Århus C
> Telefon: +45 86207800
> Direct: +45 86207810
> Fax: +45 86207801
> Email: [EMAIL PROTECTED]
> Web: www.mobilethink.dk
> ................................
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.701 / Virus Database: 458 - Release Date: 07-06-2004



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to