7 Oct 2008 03:51
Re: mysqldump
Bryan A. P. Pendleton <bp <at> geekdom.net>
2008-10-07 01:51:23 GMT
2008-10-07 01:51:23 GMT
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
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 <at> gmail.com> wrote:
On Mon, Oct 6, 2008 at 8:54 PM, Daniel Schwen <lists <at> schwen.de> wrote:Ah, I see. The databases are on different servers. I don't know how
> Cross-database queries I know, but cross-server queries are new to me. Is that
> even possible?
you'd be able to do that, no, not without a lot of manual work.
_______________________________________________
Toolserver-l mailing list
Toolserver-l <at> lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
<div><div dir="ltr">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 <a href="http://dev.mysql.com/doc/refman/5.0/en/federated-use.html">http://dev.mysql.com/doc/refman/5.0/en/federated-use.html</a><br clear="all"><br>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.<br>-- <br>Bryan A. P. Pendleton<br><br><div class="gmail_quote"> On Mon, Oct 6, 2008 at 9:03 PM, Aryeh Gregor <span dir="ltr"><<a href="mailto:Simetrical%2Bwikilist <at> gmail.com">Simetrical+wikilist <at> gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote"> <div class="Ih2E3d">On Mon, Oct 6, 2008 at 8:54 PM, Daniel Schwen <<a href="mailto:lists <at> schwen.de">lists <at> schwen.de</a>> wrote:<br> > Cross-database queries I know, but cross-server queries are new to me. Is that<br> > even possible?<br><br> </div>Ah, I see. The databases are on different servers. I don't know how<br> you'd be able to do that, no, not without a lot of manual work.<br><div> <div></div> <div class="Wj3C7c"> <br> _______________________________________________<br> Toolserver-l mailing list<br><a href="mailto:Toolserver-l <at> lists.wikimedia.org">Toolserver-l <at> lists.wikimedia.org</a><br><a href="https://lists.wikimedia.org/mailman/listinfo/toolserver-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br> </div> </div> </blockquote> </div> <br> </div></div>
RSS Feed