List:General Discussion« Previous MessageNext Message »
From:Raymond A Jr Jacob Date:June 3 2006 6:53pm
Subject:RE: Can I delete old <host>-bin.xxxxx files in order to free up some space?
View as plain text  
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
Thread
Can I delete old <host>-bin.xxxxx files in order to free up some space?Raymond A Jr Jacob3 Jun
  • Re: Can I delete old <host>-bin.xxxxx files in order to free up some space?Gary Richardson3 Jun
RE: Can I delete old <host>-bin.xxxxx files in order to free up some space?Raymond A Jr Jacob3 Jun
  • Re: Can I delete old <host>-bin.xxxxx files in order to free up some space?Gary Richardson3 Jun
RE: Can I delete old <host>-bin.xxxxx files in order to free up some space?Raymond A Jr Jacob3 Jun