You could also do: SET GLOBAL expire_log_days=n; BTW - this same hint is on the the very same manual page you mentioned at the beginning of this thread.
-- Augusto Bott On Mon, May 12, 2008 at 11:11 AM, Rick James <[EMAIL PROTECTED]> wrote: > RESET is not a good idea -- PURGE to some point is better. > > > > > > > -----Original Message----- > > From: Dennis Yu [mailto:[EMAIL PROTECTED] > > Sent: Sunday, May 11, 2008 6:10 PM > > To: Kaushal Shriyan > > Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] > > Subject: Re: MySQL purge logs > > > > login MySQL with "root" and use: > > RESET MASTER > > that's all you need to do. > > > > > > 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 > > > > > > -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 > > > > > > > > > > > > -- > > MySQL Replication Mailing List > > For list archives: http://lists.mysql.com/replication > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > -- > MySQL Replication Mailing List > For list archives: http://lists.mysql.com/replication > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]