Re: how to merge 2 tables from 2 different database?
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
Subject
Views
Written By
Posted
26874
May 19, 2006 02:06PM
14050
May 22, 2006 03:56AM
11634
June 01, 2006 11:16AM
Re: how to merge 2 tables from 2 different database?
11516
June 02, 2006 09:32AM
10553
June 02, 2006 10:10AM
9979
June 06, 2006 10:54AM
13508
August 28, 2006 04:10PM
9584
August 30, 2006 10:11AM
14256
September 05, 2006 01:35AM
8323
June 10, 2007 10:05AM
8778
June 21, 2007 01:54AM
8152
June 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.