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