Re: insert into non-replicated database from replicated database breaks replication

replicate_do_db and replicate_ignore_db options
rely only on the current db, i.e.
the one which is selected with USE (or CONNECT).
If you want something that will work for

USE a_replicated_database;
INSERT on unreplicated_database.table;

you should instead use replicate_wild_do_table
and/or replicate_wild_ignore_table.
This will work in the above case.

See the online manual on www.mysql.com
for complete explanations about these options.

--
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mgbi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Guilhem Bichot
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Software Developer
/_/ /_/\_, /___/\___\_\___/ Bordeaux, France
<___/ www.mysql.com +33 5 56 88 34 39

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13628@lists.mysql.com
To unsubscribe, e-mail