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/[EMAIL PROTECTED]