Re: Query mysql on another server

2003-01-08 Thread Chris Boget
> Why can't you use an Env variable to point to the server you want to query > from and switch the value back and forth as needed in the case that you want > to periodically switch back and forth between servers? Or write a function > that runs on server1 to query against the tables on server2 mak

RE: Query mysql on another server

2003-01-08 Thread jarnold4
g the results available to a query to be run on server1? -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: >W

Re: Query mysql on another server

2003-01-07 Thread Stefan Hinz, iConnect \(Berlin\)
70948-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

Re: Query mysql on another server

2003-01-07 Thread Chris Boget
> >You can use the command line mysql with the "host" option, i.e. > >--host=, 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 hos

RE: Query mysql on another server

2003-01-07 Thread Christensen, Dave
#x27;s database tables. -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

RE: Query mysql on another server

2003-01-07 Thread Christensen, Dave
any) 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

Re: Query mysql on another server

2003-01-07 Thread Fred Stiening
(PHP-centric response) Open another mySQL connection to the other server, and then use the link identifier in the subsequent calls to identify which server to use for the query. note that in php if you have two or more connections open, the calls generally default the link ID to the last conn

Re: Query mysql on another server

2003-01-07 Thread Ken Menzel
From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Chris Boget" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 12:11 PM Subject: Re: Query mysql on another server > At 10:08 -0600 1/7/03, Chris Boget wrote: > >We have a *nix networ

RE: Query mysql on another server

2003-01-07 Thread Paul DuBois
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). An

Re: Query mysql on another server

2003-01-07 Thread Paul DuBois
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.