replicate-rewrite-db

Hi, Any idea wat replicate-rewrite-db does with example..

Re: replicate-rewrite-db

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 slave

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

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 drop it to make sure it was working ok ( if it wasn't I didn't want to taint the existing

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

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 drop

replicate-rewrite-db

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

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 replicate-rewrite-db DN

syntax problem with replicate-rewrite-db

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 file on the slave

syntax problem with replicate-rewrite-db

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-master_mysql When I

replicate-rewrite-db

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 people

replicate-rewrite-db

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