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
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
; [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
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,
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