Re: replicate-rewrite-db

2008-04-04 Thread Dan Rogart
On Fri, Apr 4, 2008 at 6:30 AM, Shanmugam, Dhandapani < [EMAIL PROTECTED]> wrote: Hi, Hi, > > Any idea wat replicate-rewrite-db does with example.. > > > > It takes statements for one database, and rewrites them into another. An example of the syntax would be this line in the my.cnf file of your

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 > p