Hello all, I have setup a replication between two MySQL v4.01a servers on FreeBSD, which works really fine. The only problem is that since we have MANY updates on the master database, the bin-logs grow very fast. We need to do a manual clean-up at least once every other day, otherwise the disk space will get exhausted: "SHOW SLAVE STATUS" on the slave, write down the 'Log_File' name, and pass that to "PURGE MASTER LOGS TO 'logname'" on the master.
Does anybody have an idea how we could automate this procedure, or should we manage the log-files is another way? Thank you for your suggestions, Paul van Diepen VMS-Keytrade sa/nv Bld du Souverain 100 B-1170 Brussels - Belgium Phone: +32-(0)2-679.90.00 Fax: +32-(0)2-679.90.01 --------------------------------------------------------------------- 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
