Linking from another server?

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?

Thanks
Joelle Tegwen


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Linking from another server?

--=_alternative 00573201852570DF_=
Content-Type: text/plain; charset="US-ASCII"

Joelle Tegwen 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?
>
> Thanks
> Joelle Tegwen
>
>

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-eng ine.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 00573201852570DF_=--