Hi,
I have setup MySQL replication for only one database
/etc/my.cnf (master server)
binlog-do-db=knowledgebase
/etc/my.cnf (slave server)
replicate-do-db=knowledgebase
I am able to replicate the changes from master to slave, if my
application uses "use <dbname>" and then insert/delete/update
statements.
But if I used insert/delete/update statements directly (ie) "delete
from dbname.tablename;" (without "use" statement), the changes are not
replicating and also it is not logged in binlog file.
In MySQL site also they specified the problem
Ref: http://dev.mysql.com/doc/refman/4.1/en/replication-problems.html
But how to solve this. Any solutions.
MySQL version: 3.23.58 in both servers
TIA
Moorthy
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
linux-india-help mailing list
linux-india-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/linux-india-help
