Re: Problem when I rename the slave and master servers?

[Neil Davis]

I had this same issue after someone destroyed my slave server. I rebuilt it, loaded the db's in from the last good snapshot.

I got this error when trying to set the slave to the right log and position to start from.

This solution also worked in my situation. Here's what I did:

stop slave;
reset slave;
CHANGE MASTER TO MASTER_LOG_FILE='log-bin.000213', MASTER_LOG_POS=205996549;//place of last good snapshot
start slave;

Worked like a champion. Without the reset slave; I got the same error. Just thought I'd add to this thread and show another situation where you need to do this. Thx Peter~!

-Neil