Re: MySQL purge logs

[D Hill]

On Mon, 12 May 2008 at 11:58 -0400, augusto@stripped 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@stripped> wrote:
>> RESET is not a good idea -- PURGE to some point is better.
>>
>>
>>
>>
>>
>> > -----Original Message-----
>> > From: Dennis Yu [mailto:service@stripped]
>> > Sent: Sunday, May 11, 2008 6:10 PM
>> > To: Kaushal Shriyan
>> > Cc: mysql@stripped; replication@stripped
>> > 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/replication?unsub=1
>>
>>
>>>
>> >
>>
>>  --
>>  MySQL Replication Mailing List
>>  For list archives: http://lists.mysql.com/replication
>>  To unsubscribe:    http://lists.mysql.com/replication?unsub=1
>>
>>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>