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 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 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
