I'm just a lurker here, so I don't know if the toolserver machine is running a recent enough MySQL, but there is a table type called the "federated" table, see http://dev.mysql.com/doc/refman/5.0/en/federated-use.html

For the most part, this makes it possible to use a remote table that you have access to in SQL commands in the same way one might normally use a local one.
--
Bryan A. P. Pendleton

On Mon, Oct 6, 2008 at 9:03 PM, Aryeh Gregor <Simetrical+wikilist@gmail.com> wrote:
On Mon, Oct 6, 2008 at 8:54 PM, Daniel Schwen <lists@schwen.de> wrote:
> Cross-database queries I know, but cross-server queries are new to me. Is that
> even possible?

Ah, I see.  The databases are on different servers.  I don't know how
you'd be able to do that, no, not without a lot of manual work.

_______________________________________________
Toolserver-l mailing list
Toolserver-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/toolserver-l