Hi I am using MySQL version 3.23.49 with one master and one slave that can change of course. Lately I've been using the option to not replicate certain tables (replicate-ignore-table) and it is not working for inserts.
My my.cnf file in the slave looks like: [mysqld] log-bin server-id=2 binlog-do-db=db1 replicate-ignore-table= db1.table1 replicate-ignore-table= db1.table2 In the master it looks the same except for the server-id which is 1. Then I do an insert, say in table1 in the master side and it gets replicated in the slave side. I noticed in the MySQL site under "Replication Features and Known Problems" that there is a bug in the replicate-ignore-table from version that says: " The other bug is that if the ignored table gets partially updated, the slave thread will not notice that the table actually should have been ignored and will suspend the replication process" Are inserts considered "table gets partially updated"? Does anyone know something about this problem? Thanks Gil Shai --------------------------------------------------------------------- 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
