Hello.
I've setup a replication between two instances of MySQL 4.0.25, and replicate-* rules work fine. Check your replication setup one more time, and if you able to make a reproducible test case you may want to report a bug. Sometimes it is possible to find a clue to the problem in the trace file. See: http://dev.mysql.com/doc/mysql/en/making-trace-files.html mysql> show slave status \G; *************************** 1. row *************************** Master_Host: blend.ensita.net Master_User: slave Master_Port: 3736 Connect_retry: 60 Master_Log_File: log_x.003 Read_Master_Log_Pos: 600 Relay_Log_File: blend-relay-bin.002 Relay_Log_Pos: 268 Relay_Master_Log_File: log_x.003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_do_db: _rtest Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 600 Relay_log_space: 268 Statement on the master: +------------+ | database() | +------------+ | rtest | +------------+ 1 row in set (0.00 sec) mysql> update t1 set a=35; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 The results on the slave: mysql> select database(); +------------+ | database() | +------------+ | _rtest | +------------+ 1 row in set (0.00 sec) mysql> select * from t1; +------+ | a | +------+ | 35 | +------+ 1 row in set (0.00 sec) > > Sorry, if I wasn't clear enough: > Of course I am using the statements: > > replicate-rewrite-db=rtest->_rtest > replicate-do-db=_rtest > > The updates on this database do show up in the master-log-file, but > aren_t replicated. I also tried to enable > > log-slave-updates > log-warnings > > But it seems everything is logged ok (on the slave as well), it just > doesn't take place. > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
