Error 1794 loading mysql 5.6 master dump while configuring replication slave

Question

E:>mysql -u root < masterDump.db ERROR 1794 (HY000) at line 22: Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log. There was no additional messages in the error log.

In their respective my.ini files (Yes, I'm on Windows) The master server-id=1 The slave server-id=2

When I open the dump file and look at line 22 this is what I have (X's inserted for privacy): CHANGE MASTER TO MASTER_HOST='1X2.21.42.XXX', MASTER_PORT=3306, MASTER_USER='replicant', MASTER_PASSWORD='MasteAccessXXX', MASTER_LOG_FILE='mysql-bin.000004', MASTER_LOG_POS=335723162; Clearly I don't have --server-id on that line but it is not part of the "CHANGE MASTER TO" command (http://dev.mysql.com/doc/refman/5.6/en/change-master-to.html)

I started the slave like it said:

mysqld --skip-slave-start

Does anyone have an idea what I am missing?

Thanks,

Andrew

Answer 1

Ok I figured it out.

You must at least set --server-id to enable either a master or a slave. 

I thought that was needed when starting mysql but that is not a flag for that command.

I added --server-id=2 to mysqld startup and the dump file is loading.

Thanks for looking. Hope this helps someone else.

Andrew

Answer 2

try this :

• Stop slave
• CHANGE MASTER TO MASTER_DELAY = 0, RELAY_LOG_FILE = 'xxxxx-relay-bin.NNNNNN', RELAY_LOG_POS = YYYYYYYY ;
• Start slave;