>>Please can someone tell me how to run a SELECT between databases on a network. I want to SELECT some data >>from a mySQL server named PC1 to a table on a second mySQL server named PC2. Thanks in advance.
Hi, As long as you have a valid logon for each of the databases on each of the servers, you could use the mysqldump function with --where="some clause" to get it from one machine to the other. Like this: Mysqldump -u someuser -h somehost --where="column1='Yes' and column2='allowed'" somedatabase sometable | mysql -u anotheruser -h anotherhost somedatabase Hope this helps, Andrew 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
