RE: mysql-bin maintenance

2009-05-12 Thread Rolando Edwards
esday, May 12, 2009 2:53 PM To: edb...@edberg-online.com Cc: Rilawich Ango; mysql@lists.mysql.com Subject: Re: mysql-bin maintenance i tried this one PURGE { BINARY | MASTER } LOGS { TO '*log_name*' | BEFORE *datetime_expr* } but for some reason it didn't purge any bin file

Re: mysql-bin maintenance

2009-05-12 Thread Jerome Macaranas
i tried this one PURGE { BINARY | MASTER } LOGS { TO '*log_name*' | BEFORE *datetime_expr* } but for some reason it didn't purge any bin file.. so i tried our expired... on the my.cnf waited for a while and it was deleted... is there a requirement to use "purge" i have "5.0.51a-0.rhel4" run

Re: mysql-bin maintenance

2009-05-11 Thread edberg
On Mon, May 11, 2009 6:41 pm, Rilawich Ango wrote: > Hi, > In the master database, there are plenty of mysql-bin.X. It > occupied almost all the disk space. As I know, the files should be removed > by issuing reset master. Below are my questions. -Do I need to stop > replication before issuing r

mysql-bin maintenance

2009-05-11 Thread Rilawich Ango
Hi, In the master database, there are plenty of mysql-bin.X. It occupied almost all the disk space. As I know, the files should be removed by issuing reset master. Below are my questions. -Do I need to stop replication before issuing reset master? If yes, do I need to rebuild the replication