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:
We have
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 making
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?
I know that when you are using a database from
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.
: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
: 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 network and on that network we have 2
web servers. One
(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
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
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 network we
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
[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
11 matches
Mail list logo