Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk
> - to remove the bin logs: > > PURGE MASTER LOGS TO 'filename'; (where filename is the > name of the last bin log to keep) I prefer RESET MASTER - it clears and deletes all bin-log files. > - if you no longer required bin-logging enabled, you must comment out > the bin-log line in your my.cnf > Which works below versions 4.1.4, after that it appears to write bin-logs even with no log-bin line in your my.cnf file. If I manage to work out how to turn bin logging off I'll let you know - its causing us real headaches at the moment. ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
