List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:May 20 2008 3:47am
Subject:Re: purge binary logs on master
View as plain text  
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 <tlyons@stripped> 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/mysql?unsub=1
>
>


-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Thread
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