mySQL slave configration error
Posted by:
Garey Guan
Date: February 08, 2012 03:03PM
hi, experts,
i have two server A(192.168.10.249) and B(192.168.10.250), all windows server2003 with mySQL 5.5.17-log, now i want to congigure the replication from A to B, A is the master:
step 1: stop A mysql service, add
server-id = 1
log-bin
binlog-do-db=reltest
to my.ini file, and start the service.
step 2: stop B mySQL service, add
server-id = 2
master-host=192.168.10.249
master-user=DBA
master-password = ******
master-port = 3306
master-connect-retry = 10
replicate-do-db = reltest
to my.ini configure file,but when i try to start the mySQL service on server B, got Error:
Could not start the mySQL servie on local computer
Error 1067:The process teminated unexpectedly.
even i ony add
server-id = 2
master-host=192.168.10.249
also got the same error, but if i only add
server-id = 2
can start the service, why if i configure the master-host then encounter error?
A and the same workgroup, network no isssue, pls help me, Thanks
Regards
Garey
Subject
Views
Written By
Posted
mySQL slave configration error
2581
February 08, 2012 03:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.