Philippe de Rochambeau wrote:
my /var/lib/mysql directory contains many xxxx-bin.xxx files, some of which date back to October 2004. What exactly are these files? Can I safely remove the older ones?- these are the bin logs, used in replication. MySQL writes all INSERT, UPDATE, etc., and DDL commands to the bin log, and the slave reads them from there. If you're not using replication, then you can happily remove all the files except the last one. If you are, you need to check which bin log the slave is currently reading (use SHOW SLAVE STATUS), and only remove the files before that one.
- to remove the bin logs:
PURGE MASTER LOGS TO 'filename'; (where filename is the name of the last bin log to keep)
- if you no longer required bin-logging enabled, you must comment out the bin-log line in your my.cnf
- ian
-- +-------------------------------------------------------------------+ | Ian Sales Database Administrator | | | | "If your DBA is busy all the time... | | ...he's not doing his job properly" | | eBuyer http://www.ebuyer.com | +-------------------------------------------------------------------+
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
