List:General Discussion« Previous MessageNext Message »
From:Todd Lyons Date:May 19 2008 4:14pm
Subject:Re: purge binary logs on master
View as plain text  
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
Version: GnuPG v1.4.6 (GNU/Linux)

purge binary logs on masterAnanda Kumar17 May
  • Re: purge binary logs on masterJuan Eduardo Moreno17 May
    • Re: purge binary logs on masterAnanda Kumar18 May
      • Re: purge binary logs on masterTodd Lyons19 May
        • Re: purge binary logs on masterMoon's Father20 May