-->-----Original Message----- -->From: Robert Hamel [mailto:[EMAIL PROTECTED] -->Sent: Friday, September 26, 2003 1:41 PM -->every 5mins or so. We have a process to remove the bin-logs but I was -->wondering if it would be safe to remove entries or even rotate the bin -->log index. E.g. copy the existing bin log index to filename.0 then echo -->"" > bin-log index.
mySQL does this already. Use max-binlog-size or max-relaylog-size to set the max log size. This will enable mysql to rotate the log to hostname-bin.0XX. Then use the command purge MASTER LOGS TO '<binlog>' to remove the ones you don't want. Also lookup backlog to see how to automate this. --> --> -->Robert Hamel - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]