Hi, I was having problems because I had to rename my slave sever. Now I think I understand the problem better. I looked in slave.cc and found my error message and can see that it only applies to the slave. So I guess that brings up two issues. 1. Why can't the relay-log deal with the name change that the binary log has no problem with? The new binary log files just get created on restart after I change the hostname. 2. I have a running slave, what should I do to be carefull and safe and not mess up any data before I run RESET SLAVE? This command scares me. I don't like the sound of "forgeting" the binlog position. Does that mean if I do that without clearing out my relay-log that I will end up replaying the whole thing?
And last of all, would it be best to run reset slave after I have my new hostname? FreeBSD 4.6 mysql 4.0.2 slaving off of a remote server. The remote server is only binloging one database, and the slave is only replicate_do that one database. The Master has many many databases. Thanks, Eric http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant --------------------------------------------------------------------- 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