SEO

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

-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

RESET is not a good idea -- PURGE to some point is better.



> -----Original Message-----
> From: Dennis Yu [mailto:service@dennisyu.idv.tw]
> Sent: Sunday, May 11, 2008 6:10 PM
> To: Kaushal Shriyan
> Cc: mysql@lists.mysql.com; replication@lists.mysql.com
> 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/...ster-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/replication?u...@yahoo-inc.com
>
>

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 <rjames@yahoo-inc.com> wrote:
> RESET is not a good idea -- PURGE to some point is better.
>
>
>
>
>
> > -----Original Message-----
> > From: Dennis Yu [mailto:service@dennisyu.idv.tw]
> > Sent: Sunday, May 11, 2008 6:10 PM
> > To: Kaushal Shriyan
> > Cc: mysql@lists.mysql.com; replication@lists.mysql.com
> > 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/...ster-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/replication?u...@yahoo-inc.com
>
>
> >
> >
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?u...bott@gmail.com
>
>

On Mon, 12 May 2008 at 11:58 -0400, augusto@bott.com.br confabulated:

> You could also do:
> SET GLOBAL expire_log_days=n;

You forgot the 's' in log:

SET GLOBAL expire_logs_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 <rjames@yahoo-inc.com> wrote:
>> RESET is not a good idea -- PURGE to some point is better.
>>
>>
>>
>>
>>
>> > -----Original Message-----
>> > From: Dennis Yu [mailto:service@dennisyu.idv.tw]
>> > Sent: Sunday, May 11, 2008 6:10 PM
>> > To: Kaushal Shriyan
>> > Cc: mysql@lists.mysql.com; replication@lists.mysql.com
>> > 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/...ster-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/replication?u...@yahoo-inc.com
>>
>>
>>>
>> >
>>
>> --
>> MySQL Replication Mailing List
>> For list archives: http://lists.mysql.com/replication
>> To unsubscribe: http://lists.mysql.com/replication?u...bott@gmail.com
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=d...ournetplus.com
>
>

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