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
