You could have the server in Guernsey connect to the one in the US and either do a push or a pull of data. Most places won't alow inbound connections but out bound are usually allowed no problem. You can usually set up a batch or shell script to run and update the data on a regular basis.
So if you can't connect to the remote server have the remote server connect to you. mysqldump or mysqlhotcopy should be all you need to get the data moved. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Hope that helps, Dave On Sep 29, 2006, at 7:43 AM, Les Mizzell wrote: > I have a client that has a site/database hosted in the US. They've > started an international "companion" business that's located in > Guernsey, which is basically a rock in the ocean between England and > France (no offense to anybody in Guernsey - pics I've seen are > beautiful). > > The new site for them has to be hosted in Guernsey and have the co.gg > domain extension. They found exactly one Coldfusion hosting service in > Guernsey that they thought could meet their needs. > > The main site in the US is using a MySQL database for all their client > and enrollment information. They need to share that database with the > new site/host in Guernsey. The database is constantly being updated or > added two. > > The host in the US allows a remote connection to their database. In > fact, I don't have a single client with a database that the host > *doesn't* allow a remote connection. Whoop - make that one - the > hosting > company in Guernsey. No remote access there. > > So I figure, big deal, if I can't have a remote connection to the > database in Guernsey, then I'll just have them set up a DSN to the > database in the US and keep all data there, which I have permission > from > the US host to do. The same folks in the US that administer the > enrollments from the US site will be administering the Guernsey site > anyway, so I could build the admin for the whole thing into the US > site. > > The Guernsey host won't set up a DSN to a remote database either. > > So, I see no way to share data. > > Is there a CODE ONLY way to do this? Like maybe a DSN-less > connection to > the US database? Ideas? > > "Get a new host" isn't really an option I don't think - I'm going to > have to work with what I've got. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
