I have a question about how to rotate replication logs in MySQL V 3.23.49. I've tried to use the command "purge master logs to 'logname'", however, I'm unclear what to specify for 'logname'. On my master, I have several "old" log files which are no longer being used (by issuing the command "show slave status" on the slave machine. When I try to use the purge command to delete the log, I get the MySQL error: "A purgable log is in use, will not purge". When I issue the command on the active log file, I don't get any errors, but the old logs are not deleted.
What I'd like to do is to set up a mechanism where every week I rotate my replication log files and delete (or archive) the ones I no longer need. Can anyone point me to some docs where I can learn how to do this? Much thanks, -- Dave Swindell -------------------------------------------------------- C. David Swindell SimUtility, Inc 68 Tadmuck Road Westford, MA 01886 Tel: (978) 692-1008x229 Fax: (978) 692-8177 [EMAIL PROTECTED] www.simutility.com -------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php