Res: MySQL purge logs
mysql> reset master; Wagner Bianchi Diretor de Tecnologia - INFODBA C&T [EMAIL PROTECTED] - (31) 3272 - 0226 / 9114 - 7695 - Mensagem original De: Kaushal Shriyan <[EMAIL PROTECTED]> Para: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Enviadas: Domingo, 11 de Maio de 2008 13:39:02 Assunto: MySQL purge logs 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 Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/
Re: MySQL purge logs
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]
Re: MySQL purge logs
On Mon, 12 May 2008 at 11:58 -0400, [EMAIL PROTECTED] 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 <[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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL purge logs
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]
RE: MySQL purge logs
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL purge logs
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