Re: --replicate-rewrite-db fails when attempting to drop a table

2006-01-18 Thread Gleb Paharenko
Hello. You should not use a cross database syntax for you queries. Instead of 'DROP TABLE `livedb`.`test_replication`' use use livedb; DROP TABLE test_replication Ian wrote: Hi List, I have been asked to setup replication between two customers servers for one

--replicate-rewrite-db fails when attempting to drop a table

2006-01-17 Thread Ian
Hi List, I have been asked to setup replication between two customers servers for one particular database, which I will call in this post 'livedb'. The customer also has a copy of this database on the slave which they use for testing. This copy does not contains the same data as the master