Re: MySQL purge logs

[Paul DuBois <paul@xxxxxxxxx>]

On May 11, 2008, at 11:39 AM, Kaushal Shriyan wrote:

> Hi
>
> I am referring to
> http://dev.mysql.com/doc/refman/5.0/en/purge-master-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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx