2013/2/13 Robert Citek <robert.ci...@gmail.com> > On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek <robert.ci...@gmail.com> > wrote: > > Any other possibilities? Do other scenarios become likely if there > > are two or more tables? > > > > Of those, which are the most likely? > > [from off-list responder]: > > Other possibility: The replication is reading from master not from the > point when the dump was done, but some time before and is fetching insert > statements which are already in the dump. > > To prevent that I used the coordinates in the dump file included with > --master-data=2. Could the coordinates still be off?
Hello, Are you sure nothing is getting inserted directly into the slave? Is it in read only mode? If you're starting replication using the values provided by --master-data=2 (which should be something like): -- Position to start replication or point-in-time recovery from -- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000974', MASTER_LOG_POS=240814775; And if you're using the right IP, there's no reason to have duplicate entries unless someone is writing directly into the slave. Manuel.
