vangoogle Posted September 16, 2009 Share Posted September 16, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/174490-mysql-database-structure-question/ Share on other sites More sharing options...
tekrscom Posted September 17, 2009 Share Posted September 17, 2009 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... Quote Link to comment https://forums.phpfreaks.com/topic/174490-mysql-database-structure-question/#findComment-919893 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.