Hi all! I have been attempting to set up a system that involves replication and have run into some minor problems. I am only replicating one database but not all of the tables in the database. So when changes are made to the replicated dataase, it is logged to the binary log even if it is from a table i do not want to replicate. This causes problems because if i take the binary log from one machine to another and try to use it to update that machine, won't it also update the tables i explicitly wanted to not replicate. Basically in my config file i have set binlog-do-db=replicated_db replicate-do-db=replicated_db and in the slaves replicate-ignore-table=replicated_db.table1 replicate-ignore-table=replicated_db.table2 replicate-ignore-table=replicated_db.table3 what i basically wanted to knwo is if there was an option like binlog-ignore-table so that when i take the binary log over to the replicated machine and pump it in to update it, it won't change the tables which have been defined as not to be replicated? Is there any way of doing this? Thanks in advance! William --------------------------------------------------------------------- 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
