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"
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.
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'; ................. Best regards Vlady
--------------------------------------------------------------------- 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
