0

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 ?

mahesh
  • 13
  • 1
  • 2
  • 5

2 Answers2

1

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?

Community
  • 1
  • 1
Gryphius
  • 75,626
  • 6
  • 48
  • 54
0

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.

Fluffeh
  • 33,228
  • 16
  • 67
  • 80