I have two My SQL servers running on two different machines.
PC -1 ( Master)
Version :My SQL 5.1.30
IP : 192.168.0.97
PC -2 ( Slave)
Version : My SQL 5.1.30
IP : 192.168.0.37
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 http://www.howtoforge.com/mysql_database_replication