I can see where it would be nice to be able to do that. -----Original Message----- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 4:06 PM To: Christensen, Dave; 'Chris Boget'; [EMAIL PROTECTED]; Paul DuBois Subject: Re: Query mysql on another server
Paul, Dave, > If I understood the initial question correctly, your first suggestion is not > what he wants. I think he's talking about accessing two servers from the same > connection, which is not possible: [snip] > You can't write a SQL statement that refers to tables hosted by > another server. (I've seen claims that this can be done, but they always > turn out to have been made by people who haven't actually tried it.) It's possible with M$ SQL Server. I guess that's the background for this question. I've recently performed a training course for an organisation where they want to migrate from SQL Server to MySQL, and they miss this feature quite a bit. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Christensen, Dave" <[EMAIL PROTECTED]>; "'Chris Boget'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 7:35 PM Subject: RE: Query mysql on another server > At 12:28 -0600 1/7/03, Christensen, Dave wrote: > >You can use the command line mysql with the "host" option, i.e. > >--host=<hostname>, to connect to another machine. Likewise, you could set > >up a data source using ODBC to look at the database on the second host > >machine through which you could generate queries against the tables on the > >other host's database tables. > > If I understood the initial question correctly, your first suggestion is not > what he wants. I think he's talking about accessing two servers from the same > connection, which is not possible: > > > Throughout this chapter, I've been making the implicit assumption that > all the tables involved in a multiple-table operation are managed by a > single MySQL server. If this assumption is invalid, the tables become more > difficult to work with. A connection to a MySQL server is specific to that > server. You can't write a SQL statement that refers to tables hosted by > another server. (I've seen claims that this can be done, but they always > turn out to have been made by people who haven't actually tried it.) > > -- MySQL Cookbook, p671 > > > > > > >-----Original Message----- > >From: Paul DuBois [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, January 07, 2003 11:12 AM > >To: Chris Boget; [EMAIL PROTECTED] > >Subject: Re: Query mysql on another server > > > > > >At 10:08 -0600 1/7/03, Chris Boget wrote: > >>We have a *nix network and on that network we have 2 > >>web servers. One for development (server1) and one for production > >>(server2). And on each of those servers we have MySQL installed. Is > >>there a way we can query a table on server2 from server1? > > > >No. > > > >>I know that when you are using a database from the mysql command line, > >>you can query a table in another database just by using select > >>databasename.tablename. But the same method using servername doesn't > >>work. Is this even possible? > > > >No. > > > >> > >>thnx, > >>Chris > > > >sql, query > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
