cannot access data source on the web PLEASE help

[mayo5000]

Hello everyone?can someone PLEASE help?
I have created some Cold Fusion pages and the are working fine via my local
server. They connect to a MYSQL database (local server).

Now I have a host on the web (WIN) which has both Cold Fusion set up (I have a
CF DSN) and MYSQL.

Now how do I get this to work this on here?

I suppose I just upload the CFM flies as per any other upload.
But what about the DATABASE? How do transfer the database to the server so
that CF files connect to this but it in its new environment?

I tried several time and had no luck. I then created a new MYSQL database on
my webserver and tried to connect to this via creating a new datasource in thr
Cold Fusion Administrator. No luck. The error message keeps asking me if there
is a MYSQL server on the host/port that I am trying to connect to. I know there
is one as I can connect via PHP page

Can someone PLEASE help. I have been trying this now for three weeks! Driving
me crazy!! My ISP (Godaddy.com) is of no help either.

thanking in advance...

Peter

[BKBK]

- cfm pages: upload them or, if security is no issue, zip them, send them as
attachment to your Gmail, to be opened at the server, etc. etc.

- mysql: use MySQL's mysqldump command to make a backup of your
entire database on the second server, as follows:

1. Generate an SQL script for the database (on your local server)
-> mysqldump --user=root --password=a1B2c3 originaldatabasename >
databasename_create.sql


2. Copy the newly created file, databasename_create.sql , to the other server


3. Recreate the database on the second server by running the sql script, like
this:
-> mysql --user=root --password=a1B2c3 newdatabasename <
databasename_create.sql

[mayo5000]

Thanks for that BKBK.

I will certainly try that a go.

cheers

Pete


Originally posted by: BKBK
- cfm pages: upload them or, if security is no issue, zip them, send them as
attachment to your Gmail, to be opened at the server, etc. etc.

- mysql: use MySQL's mysqldump command to make a backup of your
entire database on the second server, as follows:

1. Generate an SQL script for the database (on your local server)
=> mysqldump --user=root --password=a1B2c3 originaldatabasename >
databasename_create.sql

2. Copy the newly created file, databasename_create.sql , to the other server

3. Recreate the database on the second server by running the sql script, like
this:
=> mysql --user=root --password=a1B2c3 newdatabasename <
databasename_create.sql