2 messages in com.mysql.lists.win32Re: Linking from another server?
FromSent OnAttachments
Joelle Tegwen22 Dec 2005 07:41 
SGr...@unimin.com22 Dec 2005 07:52 
Subject:Re: Linking from another server?
From:SGr...@unimin.com (SGr@unimin.com)
Date:12/22/2005 07:52:52 AM
List:com.mysql.lists.win32

Joelle Tegwen <tegw@umn.edu> wrote on 12/22/2005 10:42:14 AM:

I've got data in two different instances of MySQL(5.x) is there a way to see the databases in one from the other?

You can look at the FEDERATED engine. I think it's exactly what you are asking about. It provides the facilities for a table on server B to appear as though it resides on server A (within certain limits, of course).

http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html

Shawn Green Database Administrator Unimin Corporation - Spruce Pine