my mysql dw database works on local but not remote

Report · Jun 28, 2008

i have been working on this address book record set using mysql and dreamweaver for days now . it works fine on my local pc but not on the remote server. when i enter info and then hit the submit button i get this error: error 404 Not Found
The requested URL /mysite/< was not found on this server.

and my address book is empty and doesnt even look like its supposed to,

so im assuming i have a connection problem.

here is what is in my connection folder on remote site, maybe someone can tell me im missing something?:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_mydata = "localhost";
$database_mydata = "mydatabase";
$username_mydata = "xxxxxxx";
$password_mydata = "xxxxxxxx";
$mydata = mysql_pconnect($hostname_mydata, $username_mydata, $password_mydata) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Report · Jun 29, 2008

Make sure that the following match your server's:

$hostname_mydata = "localhost";
$database_mydata = "mydatabase";
$username_mydata = "xxxxxxx";
$password_mydata = "xxxxxxxx";

$hostname_mydata should be the IP address or server name

$database_mydata should be the database name

$username_mydata should be your username

$password_mydata should be your password

These will more than likely be different than what you are using to test locally.

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Fordwebs, LLC
http://www.fordwebs.com

"brain3" <webforumsuser@macromedia.com> wrote in message news:g47b0p$nhb$1@forums.macromedia.com...
>i have been working on this address book record set using mysql and
> dreamweaver for days now . it works fine on my local pc but not on the remote
> server. when i enter info and then hit the submit button i get this error:
> error 404 Not Found
> The requested URL /mysite/< was not found on this server.
>
> and my address book is empty and doesnt even look like its supposed to,
>
> so im assuming i have a connection problem.
>
> here is what is in my connection folder on remote site, maybe someone can tell
> me im missing something?:
>
> <?php
> # FileName="Connection_php_mysql.htm"
> # Type="MYSQL"
> # HTTP="true"
> $hostname_mydata = "localhost";
> $database_mydata = "mydatabase";
> $username_mydata = "xxxxxxx";
> $password_mydata = "xxxxxxxx";
> $mydata = mysql_pconnect($hostname_mydata, $username_mydata, $password_mydata)
> or trigger_error(mysql_error(),E_USER_ERROR);
> ?>
>

Report · Jun 29, 2008

thanks for your reply. i guess i still dont understand though.

looks like there is 2 parts to my connection code, top and bottom. maybe the top = my connection to my data base on my pc? the bottom part = connection to my remote server?

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
//top part//
$hostname_mydata = "localhost";
$database_mydata = "mydatabase";
$username_mydata = "xxxxxxx";
$password_mydata = "xxxxxxxx";

//bottom part//
$mydata = mysql_pconnect($hostname_mydata = hostname on my remote server, $username_mydata = username of my remote server, $password_mydata = password of my remote site) or trigger_error(mysql_error(),E_USER_ERROR);
?> Text Text

thanks for your help

Report · Jun 29, 2008

No you need to change the top part to reflect your server.

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Fordwebs, LLC
http://www.fordwebs.com

"brain3" <webforumsuser@macromedia.com> wrote in message news:g48h1a$3k6$1@forums.macromedia.com...
> thanks for your reply. i guess i still dont understand though.
>
> looks like there is 2 parts to my connection code, top and bottom. maybe the
> top = my connection to my data base on my pc? the bottom part = connection to
> my remote server?
>
> <?php
> # FileName="Connection_php_mysql.htm"
> # Type="MYSQL"
> # HTTP="true"
> //top part//
> $hostname_mydata = "localhost";
> $database_mydata = "mydatabase";
> $username_mydata = "xxxxxxx";
> $password_mydata = "xxxxxxxx";
>
> //bottom part//
> $mydata = mysql_pconnect($hostname_mydata = hostname on my remote server,
> $username_mydata = username of my remote server, $password_mydata = password of
> my remote site) or trigger_error(mysql_error(),E_USER_ERROR);
> ?> Text Text
>
> thanks for your help
>

Report · Jun 29, 2008

sorry this is my first making a database and connecting to a remote server. I havent found 1 tutorial that tells you exactly what you have to do. all the tutorials i have tryd only tell you what to do locally.

do you know any dreamweaver tutorials that explains how to connect to a test server and remote server using mysql?
explains what your supposed to change and where in order for it to work on the web?

Report · Jun 29, 2008

No I don't know of any, sorry.

You will just need to change the connection when you go live on the remote server.

If you don't know the remote server information you should ask your web host.

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Fordwebs, LLC
http://www.fordwebs.com

"brain3" <webforumsuser@macromedia.com> wrote in message news:g48kak$6vp$1@forums.macromedia.com...
> sorry this is my first making a database and connecting to a remote server. I
> havent found 1 tutorial that tells you exactly what you have to do. all the
> tutorials i have tryd only tell you what to do locally.
>
> do you know any dreamweaver tutorials that explains how to connect to a test
> server and remote server using mysql?
> explains what your supposed to change and where in order for it to work on the
> web?
>