Moutasem Dana wrote:
>
> hi,
>
> i have two MySQL servers and i need to run a query that retreives data
> from both servers (join two tables on different servers), how can i do
> this.
>
> Thanks.
>
> ---------------------------------------------------------------------
> 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
Hello,
You cannot do that.
Joins as any SQL statement are executed by the server, not the client;
and the server can only process data it can access.
So I see only two solutions for uour problem:
1. Write a program that will run one query on each server and
will process resulting data.
2. Use MySQL replication feature to make both databases visible
by one of your server an run your join and that server.
(I don't know how hard it is since I have never used replication
myself)
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
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
