MySQL Forums
Forum List  »  Merge Storage Engine

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

Options: ReplyQuote




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.