Re: Slave not replication? - newbie needs some help please :)

[Friedrich Clausen]

I have had the same problem and it turns out there was a server-id conflict. Do a "show slave status" on the slave. Then take note of the binlog and position on the master. After that, on the master, go the your mysql data directory and do the following:

mysqlbinlog my-host-bin.005 --position=12345

replace the my-host-bin.005 and position number with that gotten from "show slave status". This will print a dump of updates, check the "server-id" and make sure that it is not the same as the slave.

Cheers,

Fred.