Res: MySQL purge logs

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

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, use

Re: MySQL purge logs

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

Re: MySQL purge logs

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

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 >

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

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 10:4