Thank you
Raymond
that did the trick.
-----Original Message-----
From: Gary Richardson [mailto:gary.richardson@stripped]
Sent: Saturday, June 03, 2006 14:39
To: Jacob, Raymond A Jr
Cc: mysql@stripped
Subject: Re: Can I delete old <host>-bin.xxxxx files in order to free up some space?
I believe the command is PURGE MASTER LOGS TO '<host>-bin.xxxxxx' where x is between
0-9
or something like that.
On 6/3/06, Jacob, Raymond A Jr <raymond.jacob@stripped > wrote:
-----Original Message-----
From: Gary Richardson [mailto: gary.richardson@stripped]
Sent: Saturday, June 03, 2006 14:10
To: Jacob, Raymond A Jr
Cc: mysql@stripped
Subject: Re: Can I delete old <host>-bin.xxxxx files in order to free up some space?
Yes you can. Be sure not to delete the one the database is currently writing to.
Are you replicating your database?
[Jacob, Raymond A Jr] No.
Are you using them for point in time restores?
[Jacob, Raymond A Jr] No.
If you're replicating, make sure your replicas have all caught up on the files you're
deleting.
[Jacob, Raymond A Jr] To remove the excess binary update logs, and start again , should I
run the SQL command:
RESET MASTER?
Or if I don't need to reconstruct or restore a table may I just delete them are comment
log-bin out
of my.cnf and restart mysql?
thank you,
Raymond
