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 li

replicate-rewrite-db

2008-04-04 Thread Shanmugam, Dhandapani
Hi, Any idea wat replicate-rewrite-db does with example..

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

2006-01-18 Thread Gleb Paharenko
gt; leave it this way, they therefore asked if it was possible to replicate to a > different database > name, e.g. livedb_backup. > > I suggested the use of the --replicate-rewrite-db option. > > When I set this up and tested it I decided to create a new table and then >

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

2006-01-17 Thread Ian
the master and the customer wants to leave it this way, they therefore asked if it was possible to replicate to a different database name, e.g. livedb_backup. I suggested the use of the --replicate-rewrite-db option. When I set this up and tested it I decided to create a new table and then d

replicate-rewrite-db

2003-02-19 Thread Arthur Kerpician
I have the same db on master and slave and I want to use replicate-rewrite-db to change the replicating name of this db on the slave. Slave my.cnf: --- [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql.sock master-host=master.company.com master-user=repl master

re: syntax problem with replicate-rewrite-db

2002-11-20 Thread Victoria Reznichenko
David, Tuesday, November 19, 2002, 5:20:23 PM, you wrote: DN> (sorry if this is a duplicate -- I don't think the original made it) DN> Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication DN> is working fine, but I'm running into errors with the repl

syntax problem with replicate-rewrite-db

2002-11-19 Thread David Nedved
Hi All, (sorry if this is a duplicate -- I don't think the original made it) Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication is working fine, but I'm running into errors with the replicate-rewrite-db directive. Here's a snippet from my my.cnf fi

syntax problem with replicate-rewrite-db

2002-11-18 Thread David Nedved
Hi All, Running mysql 3.23.52-max binary on a RedHat 7.2 based server. Replication is working fine, but I'm running into errors with the replicate-rewrite-db directive. Here's a snippet from my my.cnf file on the slave: master-port = 3306 replicate-rewrite-db=mysql->maste

replicate-rewrite-db

2002-02-28 Thread David Cumming
Hello (Post 2) Has anyone got replicate-rewrite-db (a my.cnf entry) to work. I have replication running fine, however the rewrite doesn't work. I just want to know whether I should persist or if there is something special people had to do to get it working. I have heard / read a few p

replicate-rewrite-db

2002-02-25 Thread David Cumming
Hello Has anyone got replicate-rewrite-db (a my.cnf entry) to work. I have replication running fine, however the rewrite doesn't work. I just want to know whether I should persist or if there is something special people had to do to get it working. I have heard / read a few people saying