Skip navigation links

MySQL Forums :: Merge Storage Engine :: how to merge 2 tables from 2 different database?


Advanced Search

Re: how to merge 2 tables from 2 different database?
Posted by: Ingo Strüwing ()
Date: June 02, 2006 09:32AM

Hu. This is hot stuff.

I'm not sure if it would work like so:
UNION=('/path/to/server1/db1.table1', db2.table2)

But you can edit the .MRG file by hand. Just ensure that the server doesn't use the table while editing. And keep the line ending as it is (NL vs. CR/NL if you work on Windows).

WARNING: If it is possible that two or more servers can access the same table(s), you _must_ run all servers with the --external-locking option enabled. Otherwise the table(s) will corrupt very soon.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject Views Written By Posted
how to merge 2 tables from 2 different database? 19814 irmtfan 05/19/2006 02:06PM
Re: how to merge 2 tables from 2 different database? 11080 Ingo Strüwing 05/22/2006 03:56AM
Re: how to merge 2 tables from 2 different database? 9443 Vinayak Javaly 06/01/2006 11:16AM
Re: how to merge 2 tables from 2 different database? 9263 Ingo Strüwing 06/02/2006 09:32AM
Re: how to merge 2 tables from 2 different database? 8531 Vinayak Javaly 06/02/2006 10:10AM
Re: how to merge 2 tables from 2 different database? 7912 Ingo Strüwing 06/06/2006 10:54AM
Re: how to merge 2 tables from 2 different database? 11376 Lionel Farr 08/28/2006 04:10PM
Re: how to merge 2 tables from 2 different database? 7710 Lionel Farr 08/30/2006 10:11AM
Re: how to merge 2 tables from 2 different database? 10892 Ingo Strüwing 09/05/2006 01:35AM
Re: how to merge 2 tables from 2 different database? 6531 David Andersen 06/10/2007 10:05AM
Re: how to merge 2 tables from 2 different database? 6798 Shlomo Priymak 06/21/2007 01:54AM
1000$ if implemented 6187 David Andersen 06/27/2007 06:03PM


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.