Skip navigation links

MySQL Forums :: Replication :: Replicate Table A to a table with a different name


Advanced Search

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


Subject Views Written By Posted
Replicate Table A to a table with a different name 3240 David Parker 03/06/2007 05:51PM
Re: Replicate Table A to a table with a different name 1380 Aravind Babu Miryala 04/18/2007 10:04PM


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.