On Dec 8, 2004, at 9:12 AM, Jay Ess wrote:
I am not using cross database updates. It is all on one database but
the update uses two tables.
The query "update content_review_site as a,site_rating_factors as b
set a.overall_rating = 77 where a.content_id=243" is a stripped down
version of a bigger
Eric Bergen wrote:
Jay,
Are you using the replicate-do-db option on the slave? This option
relies on 'use' being set correctly when the query is issued. A quote
from the manual explains it better than I can:
"Tells the slave to restrict replication to statements where the
default database (that i
Jay,
Are you using the replicate-do-db option on the slave? This option
relies on 'use' being set correctly when the query is issued. A quote
from the manual explains it better than I can:
"Tells the slave to restrict replication to statements where the
default database (that is, the one selecte
I have a problem with an update query not replicating through to the slave.
The query is "update content_review_site as a,site_rating_factors as b set
a.overall_rating = 77 where a.content_id=243"
Version : 4.0.22
OS : Linux X86
How to replicate the error.
CREATE TABLE content_review_site (
con