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 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 > > > >PURGE MASTER LOGS BEFORE '2008-05-07 00:00:00'; > >But it did not work. Can you please help me on this > > I was going to say drop the time stamp and just use the date, but it > works the same for me using '2008-05-XX 00:00:00' as it does using > '2008-05-XX'. Just confirming that your command does seem correct, > dunno why it's not working for you. > - -- > Regards... Todd > when you shoot yourself in the foot, just because you are so neurally > broken that the signal takes years to register in your brain, it does > not mean that your foot does not have a hole in it. --Randy Bush > Linux kernel 2.6.22-14-generic 6 users, load average: 0.89, 0.61, 0.40 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFIMad/Y2VBGxIDMLwRAirdAJ9+76Ew8AB5Y6FurP4zF8l9Q60p5gCcDtKi > 8qQbhM/cExUYVsoFhgS4Vm8= > =THsx > -----END PGP SIGNATURE----- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn