Res: MySQL purge logs

2008-05-15 Thread Wagner Bianchi
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

RE: MySQL purge logs

2008-05-12 Thread Rick James
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

Re: MySQL purge logs

2008-05-12 Thread Augusto Bott
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

Re: MySQL purge logs

2008-05-12 Thread D Hill
; [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

Re: MySQL purge logs

2008-05-12 Thread Paul DuBois
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,

MySQL purge logs

2008-05-11 Thread Kaushal Shriyan
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

Re: MySQL purge logs

2008-05-11 Thread Dennis Yu
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