> 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
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
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
> >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
#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
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
(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
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
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
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.
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 t
11 matches
Mail list logo
