View Single Post
Old 9th September 2010, 09:02
jithinkcs jithinkcs is offline
Junior Member
Join Date: Sep 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default My SQL Replication issue ?

Hi Guys,

I have two My SQL servers running on two different machines.

PC -1 ( Master)
Version :My SQL 5.1.30
IP :

PC -2 ( Slave)
Version : My SQL 5.1.30
IP :

I have two databases running on PC-1. After the successfull configuration of MySQL replication , i started the slave. And i found that the the database 1 is replicating fine . At the same time database 2 is not at all replicating . So in order to check out the database 2 replication issue , i just made some changes to database 2 in PC-1 (matster) and check for the changes in PC-2 ( Slave). Unfortunatly its not replicating , and i found that database-1 also failed the replication. Again i changed the configuration in my.ini in master and slave. But the Database1 is replicating and databse 2 failed in replication.

Please help me to solve the issue .. I attached my master my.ini,slave my.ini file and mysql log of slave.

I configured musql replication based on this link
Attached Files
File Type: txt my.ini Master.txt (5.1 KB, 215 views)
File Type: txt my.ini Slave.txt (5.1 KB, 207 views)
File Type: txt Slave mysql log.txt (7.9 KB, 471 views)
Reply With Quote
Sponsored Links