MySQL Forums :: Merge Storage Engine :: how to merge 2 tables from 2 different database?
Re: how to merge 2 tables from 2 different database?
Posted by: Ingo Strüwing ()
Date: June 06, 2006 10:54AM
No.
The .MRG file needs file path names. The server tries to access the tables via the file system. Not via the network. If you really want to use tables from other machines, you need to mount the foreign file system via NFS or similar.
The UNION clause may perhaps support path names, but it definitely does not support node names or numbers.
Regards
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
The .MRG file needs file path names. The server tries to access the tables via the file system. Not via the network. If you really want to use tables from other machines, you need to mount the foreign file system via NFS or similar.
The UNION clause may perhaps support path names, but it definitely does not support node names or numbers.
Regards
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
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.
© 2013, Oracle Corporation and/or its affiliates