Migrating site Application file

in Cartweaver ColdFusion • 4 months ago

I just moved my client's site to a new host since the old host dropped CF. Everything has transferred over fine, but I can't get the connection to the database working.

It has been years since I worked on this site originally, so I don't remember how all of this worked and the documentation I found only tells what to do with an Access database. We're on a mysql database.

What files do I need to edit to make this work on the new host? Application.cfm only? I put in localhost as the datasource name, but the site throws and error and says it find it. I'm not even sure what questions to ask my host at this point.

Replies(2)

Lawrence .. Team Cartweaver

Re: Migrating site Application file

4 months ago

First you will need to create a database on your new server
Create / or have your host provide you with a username and password to this database
Have the host provide you with the remote connection URL for the database so you can move your current database to the new location
Using a good MySQL Utility - I HIGHLY recommend Navicat MySQL - commercial version - best hundred bucks you'll ever spend - move the database contents over to the new site. Doing this with Navicat you will be able to create remote connections to both the old database and the new database, then simply "drag-n-drop" all the database tables, fields and data over to the new location. With other utilities you may need to create a saved backup of the old location then use the saved script to restore the database to the new location.
Create or have your new host create a CF data source to your new database
Now modify the appropriation lines in the <cfmodule tag in your Application.cfm file
Save and upload - you should be good to go.

Here's a little time saving tip: While you are at it, create a local copy of the database to your local development MySQL database, then create a user with full permissions to this database, giving thew user name ad password that are identical to the hose server. Next on your local CF Server create a local data source name for this database using again the identical DSN that you will be using on the host server. Doing this will allow you to use the same settings in your Application.cfm file in both locations - otherwise no worries about trying to maintain to different copies of this file.

Lawrence Cramer
Cartweaver.com
Stay updated:
http://www.facebook.com/Cartweaver
http://www.twitter.com/Cartweaver
http://blog.cartweaver.com

rethink

Re: Migrating site Application file

4 months ago

Having my host create the CF DSN was just what I was missing. All is working beautifully now--thanks so much!

Top Reply

Response title

Attachments

New to this Portal?