At 14:38 -0700 4/27/06, P. Evans wrote:
Hello Listers,
Is it possible to run a query on one mysql server to another
database on a different server ?
eg creating an alias in database A on server A to table B on
database B on server B ?
Like a federated nickname on db2 udb or synonym on informix ?
You can use FEDERATED to access tables on other MySQL servers.
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]