On May 11, 2008, at 11:39 AM, Kaushal Shriyan wrote:
> Hi
>
> I am referring to
> http://dev.mysql.com/doc/refman/5.0/...ster-logs.html
>
> whats the exact syntax to purge this MySQL Binary Logs
It's as indicated on the page that you reference. For example,
to purge all logs before .000698, use
PURGE MASTER LOGS TO 'host1-bin.000698';
To purge all logs older than May 7, use
PURGE MASTER LOGS BEFORE '2008-05-07 00:00:00';
> -rw-rw---- 1 mysql 701 1.1G May 5 07:39 host1-bin.000681
> -rw-rw---- 1 mysql 701 1.1G May 5 09:09 host1-bin.000682
> -rw-rw---- 1 mysql 701 1.1G May 5 10:49 host1-bin.000683
> -rw-rw---- 1 mysql 701 1.1G May 5 20:24 host1-bin.000684
> -rw-rw---- 1 mysql 701 1.1G May 5 21:47 host1-bin.000685
> -rw-rw---- 1 mysql 701 1.1G May 5 23:31 host1-bin.000686
> -rw-rw---- 1 mysql 701 1.1G May 6 01:40 host1-bin.000687
> -rw-rw---- 1 mysql 701 1.1G May 6 04:26 host1-bin.000688
> -rw-rw---- 1 mysql 701 1.1G May 6 07:00 host1-bin.000689
> -rw-rw---- 1 mysql 701 1.1G May 6 08:58 host1-bin.000690
> -rw-rw---- 1 mysql 701 1.1G May 6 17:54 host1-bin.000691
> -rw-rw---- 1 mysql 701 1.1G May 6 21:01 host1-bin.000692
> -rw-rw---- 1 mysql 701 1.1G May 6 22:46 host1-bin.000693
> -rw-rw---- 1 mysql 701 1.1G May 7 00:56 host1-bin.000694
> -rw-rw---- 1 mysql 701 1.1G May 7 02:52 host1-bin.000695
> -rw-rw---- 1 mysql 701 1.1G May 7 05:44 host1-bin.000696
> -rw-rw---- 1 mysql 701 1.1G May 7 07:28 host1-bin.000697
> -rw-rw---- 1 mysql 701 1.1G May 7 09:09 host1-bin.000698
> -rw-rw---- 1 mysql 701 1.1G May 7 18:40 host1-bin.000699
> -rw-rw---- 1 mysql 701 1.1G May 7 21:00 host1-bin.000700
> -rw-rw---- 1 mysql 701 1.1G May 7 22:35 host1-bin.000701
> -rw-rw---- 1 mysql 701 1.1G May 8 00:40 host1-bin.000702
> -rw-rw---- 1 mysql 701 1.1G May 8 03:20 host1-bin.000703
> -rw-rw---- 1 mysql 701 1.1G May 8 05:53 host1-bin.000704
> -rw-rw---- 1 mysql 701 1.1G May 8 07:59 host1-bin.000705
> -rw-rw---- 1 mysql 701 1.1G May 8 09:24 host1-bin.000706
> -rw-rw---- 1 mysql 701 1.1G May 8 18:36 host1-bin.000707
> -rw-rw---- 1 mysql 701 1.1G May 8 21:21 host1-bin.000708
> -rw-rw---- 1 mysql 701 1.1G May 8 22:57 host1-bin.000709
> -rw-rw---- 1 mysql 701 1.1G May 9 01:25 host1-bin.000710
> -rw-rw---- 1 mysql 701 1.1G May 9 03:41 host1-bin.000711
> -rw-rw---- 1 mysql 701 1.1G May 9 06:05 host1-bin.000712
> -rw-rw---- 1 mysql 701 1.1G May 9 07:50 host1-bin.000713
> -rw-rw---- 1 mysql 701 1.1G May 9 09:29 host1-bin.000714
> -rw-rw---- 1 mysql 701 1.1G May 9 19:20 host1-bin.000715
> -rw-rw---- 1 mysql 701 1.1G May 9 21:46 host1-bin.000716
>
> Thanks and Regards
>
> Kaushal
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com