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
PROTECTED]> wrote: > >> Hi All, >> I using this command to purge binary logs on master, but i dont see the >> binary logs getting deleted. These binary logs are listed in index file. >> I am using mysql version 5.0.41 community version. Can you please let m

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 > bi

purge binary logs on master

2008-05-17 Thread Ananda Kumar
Hi All, I using this command to purge binary logs on master, but i dont see the binary logs getting deleted. These binary logs are listed in index file. I am using mysql version 5.0.41 community version. Can you please let me know if any thing else need to be done for this to work. log-bin is