Bug #216 Replication issues with 'UPDATE database.table'
Submitted: 1 Apr 2003 2:36 Modified: 1 Apr 2003 6:29
Reporter: Simon Dixey Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:4.0.12-nt OS:Microsoft Windows (Windows 2000 SP3)
Assigned to: Guilhem Bichot CPU Architecture:Any

[1 Apr 2003 2:36] Simon Dixey
I am using MySQL Replication with a Master and one Slave.

Using the command-line client and doing:
UPDATE database.table
..changes are made to master only, however..
USE database
UPDATE table
..replicates on both sources.

How to repeat:
d:\mysql\bin\mysql -e "UPDATE enquiry.details SET dMake = 'Panasonic' WHERE dID = 7;"
..causes the master table to update, but not the slave.

Changing the syntax to:
d:\mysql\bin\mysql -e "USE enquiry; UPDATE details SET dMake = 'Panasonic' WHERE dID = 7;"
[1 Apr 2003 6:29] Peter Zaitsev
This does not seems like a bug but using
replicate-do-db=database  or similar option.

If you still feel like this is a bug please provide us with full master and slave configuration files as well as complete 
set of statements required to repeat the problem.