boo_lolly Posted August 1, 2008 Share Posted August 1, 2008 I'm writing a script and building a database on two different servers. The script will pull from the database which is on a separate server and populate results on a page hosted on the other server. How would I do this? An example script of a connection would be perfect. Thanks! By the way, both of these servers have static IP addresses. Link to comment https://forums.phpfreaks.com/topic/117743-connecting-to-mysql-database-on-another-server/ Share on other sites More sharing options...
monkeytooth Posted August 1, 2008 Share Posted August 1, 2008 Yea its possible pending you have permissions on the other offsite database. But the connection method is no diffrent from your current one on site.. other then the physical address's login's etc.. so if you take your existing connection method, copy it, then change what you need to connect to the offsite database accordingly and you should be fine. In personal theroy you could easily connect to a couple hundred databases simotainously and gather info from them.. would be a mess im sure unless you script accordingly but overall doable I would assume. Link to comment https://forums.phpfreaks.com/topic/117743-connecting-to-mysql-database-on-another-server/#findComment-605615 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.