MySQL Forums
Forum List  »  Replication

MySQL 5.0-Can't start the service after saving the replication entries in my.ini
Posted by: Vad Rathees
Date: October 08, 2014 08:41AM

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>

Options: ReplyQuote


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


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.