Res: MySQL purge logs
mysql> reset master;
Wagner Bianchi
Diretor de Tecnologia - INFODBA C&T
wagnerbianchi@xxxxxxxxxxxxxx - (31) 3272 - 0226 / 9114 - 7695
----- Mensagem original ----
De: Kaushal Shriyan <kaushalshriyan@xxxxxxxxx>
Para: mysql@xxxxxxxxxxxxxxx
Cc: replication@xxxxxxxxxxxxxxx
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/