How Can I select/update records between 2 servers?

Discussion in 'MySQL' started by pedong, Aug 28, 2008.

  1. #1
    We are using Mysql Control Center to access all our database from all different servers with installed Linux as OS and MySQL as database. What I wanted to do is to select/update tables from server1 to server2 and vice versa.. I hope you guys understand what I'm saying.. Thanks in advance
     
    pedong, Aug 28, 2008 IP
  2. JEET

    JEET Notable Member

    Messages:
    3,832
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #2
    You can do it by connecting to mysql via server IP instead of localhost. If I remember correctly, you need to allow connections from server1 IP to server2 Database, and vice versa.
    regards :)
     
    JEET, Aug 28, 2008 IP