Re: purge binary logs on master

2008-05-19 Thread Moon's Father
You can add this condition in the configuration file if you didn't find other way to solve this. expire_logs_per_day = 4 On Tue, May 20, 2008 at 12:14 AM, Todd Lyons <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda K

Re: purge binary logs on master

2008-05-19 Thread Todd Lyons
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda Kumar wrote: >I want to purge bin logs which are older than 4 days. I want to keep 4 days >of bin logs so that in the event of any data issue, i can restore it from >bin logs. So, i tired to use > >PURG

Re: purge binary logs on master

2008-05-18 Thread Ananda Kumar
Hi Juan, I want to purge bin logs which are older than 4 days. I want to keep 4 days of bin logs so that in the event of any data issue, i can restore it from bin logs. So, i tired to use PURGE MASTER LOGS BEFORE '2008-05-07 00:00:00'; But it did not work. Can you please help me on this regards

Re: purge binary logs on master

2008-05-17 Thread Juan Eduardo Moreno
Ananda, Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in your disk'; Regards On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > I using this command to purge binary logs on master, but i dont see the > binary logs getting deleted. These