MySQL 5.0-Can't start the service after saving the replication entries in my.ini
Hi,
We have two Windows7 machines running MySQL 5.0 and we are trying to set up Master-Master replication.
I couldn't restart the MySQL service after I save the replication entries in the my.ini file of ServerA (as below). When I delete those entries from my.ini file, the service can be restarted.
I have the similar replication entries on ServerB (as below) but it works well.
Could someone help me to solve this problem with ServerA?
Thanks
ServerA
==============
[mysqld]
server-id=1
replicate-same-server-id=0
auto-increment-increment=2
auto-increment-offset=1
master-host=10.0.14.210
master-user=Repl_Ser
master-password=<password>
master-connect-retry=60
replicate-do-db=<database>
log-bin=C:\Program Files (x86)\MySQL\log\log-bin.log
binlog-do-db=<database>
ServerB
==============
[mysqld]
server-id=2
replicate-same-server-id=0
auto-increment-increment=2
auto-increment-offset=2
master-host=10.0.14.210
master-user=Repl_Ser
master-password=<password>
master-connect-retry=60
replicate-do-db=<database>
log-bin=C:\Program Files (x86)\MySQL\log\log-bin.log
binlog-do-db=<database>
Subject
Views
Written By
Posted
MySQL 5.0-Can't start the service after saving the replication entries in my.ini
1637
October 08, 2014 08:41AM
702
October 10, 2014 07:52PM
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.