MySQL Forums
Forum List  »  Replication

Replicate Table A to a table with a different name
Posted by: David Parker
Date: March 06, 2007 05:51PM

Here's the situation:
Database 1 contains Table A.
Database 2 contains Table A. (which is different than the first Table A)

Databases 1 and 2 are on different servers

I want to replicate certain tables from certain databases into a single database on a single server, while simultaneously renaming the tables to prevent naming conflicts. So, something like the following needs to happen:

database1.tablea replicates to replica.db1_tablea
database2.tablea replicates to replica.db2_tablea

Is it possible to set this up using MySql replication? If so, how would I go about it? If not, what can I do to accomplish the same goal?

Thanks in advance for any help anyone can provide!

Options: ReplyQuote

Written By
Replicate Table A to a table with a different name
March 06, 2007 05:51PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.