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