Workaround: issue "USE db" before the INSERT.
Rick James
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Alper Oguz [mailto:alper2@stripped]
> Sent: Wednesday, January 06, 2010 6:15 AM
> To: replication@stripped
> Subject: Don't replicating without USE db;
>
> Hello,
>
> I've two Mysql 5 servers that work on master-master
> replication. Both are
> Mysql 5.0.51a on Debian 5 machines.
>
> I've discover this issue on my system:
>
> http://bugs.mysql.com/bug.php?id=37483
>
> Our developers sometimes use queries like INSERT INTO
> db.table... and these
> rows aren't replicated to the second server.
>
> There is a suggestion to remove binlog-do-db lines from
> my.cnf end of that bug
> entry. (I know, this is not a bug)
>
> But how to work replication without binary logs? Could you
> please inform me?
>
> thank you
>
>
> --
> Alper Oguz
> alper2@stripped
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>
