Skip to main content
June 29, 2008
Question

my mysql dw database works on local but not remote

  • June 29, 2008
  • 1 reply
  • 427 views
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);
?>
This topic has been closed for replies.

1 reply

Inspiring
June 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);
> ?>
>
June 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