RE: MySQL Replication Binary Logs - How Long to Keep?

2006-08-12 Thread Warren Crigger
> Note that you should not just delete the bin logs. Instead > use PURGE MASTER LOGS. See > http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html > > hth, > mark Sorry, accidently hit Ctrl/Enter :( Anyway, I can't purge with that command: mysql> PURGE MASTER LOGS TO 'mysql-bin.023';

MySQL Replication Binary Logs - How Long to Keep?

2006-08-09 Thread Warren Crigger
I've just recently set up MySQL replication amongst two servers so I'm not too familiar with it. I was cleaning up my /var filesystem and found the binary data below being stored in /var/lib/mysql, taking up 1.5gb. I did a little reading on mysql.org docs. My interpretation was that you can ha