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 selected by USE) is db_name. To specify more than one database, use this option multiple times, once for each database. Note that this will not replicate cross-database statements such as UPDATE some_db.some_table SET foo='bar' while having selected a different database or no database" URL:http://dev.mysql.com/doc/mysql/en/Replication_Options.html Other possibilities are to use show slave status; and show master status; to make sure queries are actually being sent from the master to the slave. -Eric On Wed, 08 Dec 2004 00:57:42 +0100, Jay Ess <[EMAIL PROTECTED]> wrote: > 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 ( > content_id int(11) unsigned NOT NULL default '0', > site_id int(10) unsigned NOT NULL default '0', > overall_rating float(4,2) unsigned NOT NULL default '0.00', > rating_software_and_graphics tinyint(4) unsigned NOT NULL default '0', > rating_game_variety tinyint(4) unsigned NOT NULL default '0', > rating_maximum_bonus tinyint(4) unsigned NOT NULL default '0', > rating_bonus_match tinyint(4) unsigned NOT NULL default '0', > rating_wagering_requirements tinyint(4) unsigned NOT NULL default '0', > rating_payout_ratio tinyint(4) unsigned NOT NULL default '0', > rating_multiplayer_games tinyint(4) unsigned NOT NULL default '0', > rating_loyalty_bonus tinyint(4) unsigned NOT NULL default '0', > rating_deposit_withdrawal_options tinyint(4) unsigned NOT NULL default '0', > rating_support tinyint(4) unsigned NOT NULL default '0', > rating_progressive_jackpots tinyint(4) unsigned NOT NULL default '0', > rating_languages tinyint(4) unsigned NOT NULL default '0', > rating_reputation_fairness tinyint(4) unsigned NOT NULL default '0', > rating_free_bonus tinyint(4) unsigned NOT NULL default '0', > create_ts datetime NOT NULL default '0000-00-00 00:00:00', > modify_ts datetime NOT NULL default '0000-00-00 00:00:00', > PRIMARY KEY (content_id,site_id) > ) TYPE=MyISAM; > > CREATE TABLE site_rating_factors ( > site_id int(11) unsigned NOT NULL default '0', > factor_software_and_graphics tinyint(4) unsigned NOT NULL default '0', > factor_game_variety tinyint(4) unsigned NOT NULL default '0', > factor_bonus_amount tinyint(4) unsigned NOT NULL default '0', > factor_bonus_clauses tinyint(4) unsigned NOT NULL default '0', > factor_payout_ratio tinyint(4) unsigned NOT NULL default '0', > factor_multiplayer_games tinyint(4) unsigned NOT NULL default '0', > factor_loyalty_bonus tinyint(4) unsigned NOT NULL default '0', > factor_deposit_withdrawal_options tinyint(4) unsigned NOT NULL default '0', > factor_support tinyint(4) unsigned NOT NULL default '0', > factor_graphics tinyint(4) unsigned NOT NULL default '0', > factor_progressive_jackpots tinyint(4) unsigned NOT NULL default '0', > factor_languages tinyint(4) unsigned NOT NULL default '0', > factor_reputation_fairness tinyint(4) unsigned NOT NULL default '0', > factor_free_bonus tinyint(4) unsigned NOT NULL default '0', > create_ts datetime NOT NULL default '0000-00-00 00:00:00', > modify_ts datetime NOT NULL default '0000-00-00 00:00:00', > PRIMARY KEY (site_id) > ) TYPE=MyISAM; > > insert into site_rating_factors values > (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,now(),now()); > insert into content_review_site values > (243,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,now(),now()); > > On the slave get the data with "load data from master". > Both slave and master shows : > +------------+----------------+ > | content_id | overall_rating | > +------------+----------------+ > | 243 | 1.00 | > +------------+----------------+ > > update content_review_site set overall_rating = 666; > updates the tables just fine on both slave and master. > > But the troubling query below does NOT it only updates on the master. > > update content_review_site as a,site_rating_factors as b set a.overall_rating > = > 77 where a.content_id=243; > > Any suggestions? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
