Mysql on different servers

Is it possible to connect to different databases on different servers
so i can merge them as one.

I heard there is a tool that does this but still to come accross it
any help appreciated.[posted and mailed]

kev (bairdoid@.hotmail.com) writes:
> Is it possible to connect to different databases on different servers
> so i can merge them as one.
> I heard there is a tool that does this but still to come accross it
> any help appreciated.

In MS SQL Server you would set up a linked server and use four-part notation
for your queries:

SELECT * FROM SERVER.db.dbo.tbl

But what MySQL offers, I have no idea. You need to find a forum devoted
to MySQL.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp