Monday, 12 August 2013

Error 1794 loading mysql 5.6 master dump while configuring replication slave

Error 1794 loading mysql 5.6 master dump while configuring replication slave

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;

1 comment: