On 4/27/06, P. Evans <[EMAIL PROTECTED]> 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 ? > > Thanks > Pierre > > > --------------------------------- > Yahoo! Mail goes everywhere you do. Get it on your phone. >
Yes there is, please look at the FEDERATED Storage Engine starting from Mysql 5.0.3, but you need the MySQL-Max Binary distribution for the engine.. http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html Kishore Jalleda http://kjalleda.googlepages.com/projects