CODEWITHSUNDEEP
mysql
mahesh
mahesh

Reputation: 13

database link between two mysql servers running in two different locations

Please tell me how to connect to mysql database server from another mysql database server running in two different locations and access all the tables and update them ?

Upvotes: 0

Views: 21029

Answers (2)

Fluffeh
Fluffeh

Reputation: 33542

You could pop a MySQL Proxy client between the two servers and send your queries to it and let it do all the talking backwards and forwards between the other boxes.

Upvotes: 0

Gryphius
Gryphius

Reputation: 79006

afaik there is no direct "database link" in mysql like there is in oracle. what you can do is master-master replication of two databases and then update locally. similar question with more info:

Oracle Database Link - MySQL Equivalent?

Upvotes: 1

Related Questions