On Tuesday 11 March 2003 18:57, vlady wrote:
> I am trying to set up a replication ignoring a given database, but
> unfortunatly it doesn't works (for me).
> In my.cnf of my master I have at the end :
> log-bin
> server-id = 1
> binlog-ignore-db=access
>
> The line: " binlog-ignore-db=access " is supposed to make the master not
> to log updates for db "access", but but it doesn't, and I can see it
> examinig my bin log with "mysqlbinlog"
Because you explicitly specify database in your query. Check the manual:
http://www.mysql.com/doc/en/Binary_log.html
binlog-ignore-db=database_name - Tells the master that updates where the
current (i.e. selected) database is 'database_name' should not be stored in
the binary log. Note that if you use this you should ensure that you only do
updates in the current database.
> In the other hand on my repication in my.cnf I have:
> replicate-ignore-db=access
>
> which is supposed to make the repication to not replicate for db
> "access", but again it doesn't do this.
The same. If you specify replicate-ignore-db=access, slave ignores all queries
in the binary logs that listed after "use access":
http://www.mysql.com/doc/en/Replication_Options.html
> I know that it should works, so I suppose there is some misudrestanding
> at my side, so please help me with that.
>
> There are a couple of my update queries in my bin-log:
> update access.lastCheck set id = '7147671' where id = '123';
> update access.lastCheck set id = '7147670' where id = '345';
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
