Author Topic: MySQL Database structure question  (Read 258 times)

0 Members and 1 Guest are viewing this topic.

Offline vangoogleTopic starter

  • Irregular
  • Posts: 1
    • View Profile
MySQL Database structure question
« on: September 16, 2009, 01:46:21 PM »
okay so I have 3 databases lets call maintenance, userinfo, training. I have multiple servers each having these 3 MySQL databases and each server has a unique name. Now I want to have one Server with all the information from all the Servers with their corresponding databases, how do I create a Database structure to hold the information so that I can just search or select multiple Server names and then be brought to their corresponding databases?    what would the best way to do this and I can not change anything on the original Servers with Databases. 
thanks

Offline tekrscom

  • Enthusiast
  • Posts: 112
    • View Profile
Re: MySQL Database structure question
« Reply #1 on: September 17, 2009, 01:18:43 AM »
Well to start with, you'd have to allow for remote connections, if they are shared hosting servers, they probably won't allow it. If however they aren't shared hosting servers, I'm sure you can just set up 3 different connection strings...