Page 1 of 1

MySQL multiple remote database join

Posted: Fri Feb 20, 2009 3:37 am
by jaoudestudios
Hi all,

Its been a while. I started a new job so have not been around much.

I am trying to do a join across 2 databases that are on different servers. I can do a join across the 2 databases if they are on the same server.

Is it possible if they are on different servers?

Thanks.

Re: MySQL multiple remote database join

Posted: Fri Feb 20, 2009 3:43 am
by VladSun

Re: MySQL multiple remote database join

Posted: Fri Feb 20, 2009 3:47 am
by jaoudestudios
Thanks for the quick reply.

Not the answer I was hoping for though :(

Cheers :)

Re: MySQL multiple remote database join

Posted: Fri Feb 20, 2009 5:05 am
by jaoudestudios
Apparently it is possible...
http://stackoverflow.com/questions/3382 ... sql/569011
Dont know full details yet, I added a comment to confirm.

Re: MySQL multiple remote database join

Posted: Fri Feb 20, 2009 8:06 am
by jaoudestudios
Ignore what I said, they are on the same server. :(