Hi I've got a master database with 2 slaves. I've had them up and running for quite a while now with no problems, but today I noticed an error - there was a slave running on the master!
I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a good while anyway). I looked everywhere else mysql looks for my.cnf files but there were none. I tried to stop the slave by running SLAVE STOP - it said 0 rows changed and SHOW SLAVE STATUS showed that the slave was still running! I stopped mysql, moved the master.info and restarted mysql - this fixed the problem (none of the proper slaves reported any errors at any point) but I'm still a little worried why this happened. The master.info created on the master is shown below (I've put in the \n's so you can see where there were blank lines): \n 4\n \n test\n \n 3306\n 60\n Anyone have any ideas why this might have happened? This error first started when one of my colleagues restarted mysql today, but we restart it fairly regularly, I checked the command he used - it was fine. FYI - we run Redhat 7.2. Kind regards Liz --------------------------------------------------------------------- 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
