Reply
How to set up a database to a site pls help
Old 09-30-2007, 04:12 AM How to set up a database to a site pls help
Skilled Talker

Posts: 96
Name: james belcher
Hi Guys

I have been looking for a recipet site for some time and found edpudol post http://www.webmaster-talk.com/website-content-for-sale/103974-100-000-lyrics-5000-recipe-database.html

Ok so I have downloaded the database and also the script to run the database. Can someone kindly let me know how to instal all this tuff please.

I obviously upload all the site files to the server and also import the database but im unsure how to connect the two?

Thanks

James
James B is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
     
Old 09-30-2007, 06:08 AM Re: How to set up a database to a site pls help
chrishirst's Avatar
Super Moderator

Posts: 12,803
Location: Blackpool. UK
I would have thought that the best place to start would be with the vendor.

Alternatively there is probably a configuration file where you put in the database and user details.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 09-30-2007, 07:44 AM Re: How to set up a database to a site pls help
Skilled Talker

Posts: 96
Name: james belcher
Cheers.

I think it is a problem with what Im putting in.

<?php
$dbname="";// *****
$dbuser=""; // *****
$dbpass=""; // &&&&&&
$dbpath = "localhost";// enter your db path by default localhost
$db = @ mysql_connect("$dbpath","$dbuser","$dbpass");
@ mysql_select_db("$dbname",$db);
$domain = "i put site name in here.info"; //Enter your domain here for SEO purpose only
$siteurl ="http://www.i put site name in here.info"; // please specify your site url
$pubId=""; // your google Pub ID
$url="http://www.i put site name in here.info"; // no / at the end of url

?>

OK this bit is what I have used to set up the database at the server end.

$dbname="";// *****
$dbuser=""; // *****
$dbpass=""; // &&&&&&

Im stuck at what to change here, if anything?

$dbpath = "localhost";// enter your db path by default localhost
$db = @ mysql_connect("$dbpath","$dbuser","$dbpass");
@ mysql_select_db("$dbname",$db);

If any one can help that would be nice.

Thanks

James
James B is offline
Reply With Quote
View Public Profile
 
Old 09-30-2007, 01:31 PM Re: How to set up a database to a site pls help
edpudol's Avatar
Super Spam Talker

Posts: 916
Quote:
Originally Posted by James B View Post
Cheers.

I think it is a problem with what Im putting in.

<?php
$dbname="";// *****
$dbuser=""; // *****
$dbpass=""; // &&&&&&
$dbpath = "localhost";// enter your db path by default localhost
$db = @ mysql_connect("$dbpath","$dbuser","$dbpass");
@ mysql_select_db("$dbname",$db);
$domain = "i put site name in here.info"; //Enter your domain here for SEO purpose only
$siteurl ="http://www.i put site name in here.info"; // please specify your site url
$pubId=""; // your google Pub ID
$url="http://www.i put site name in here.info"; // no / at the end of url

?>

OK this bit is what I have used to set up the database at the server end.

$dbname="";// *****
$dbuser=""; // *****
$dbpass=""; // &&&&&&

Im stuck at what to change here, if anything?

$dbpath = "localhost";// enter your db path by default localhost
$db = @ mysql_connect("$dbpath","$dbuser","$dbpass");
@ mysql_select_db("$dbname",$db);

If any one can help that would be nice.

Thanks

James

You only need to provide your database name, database password , and database user name

e.g.

$dbname="mydbname_database";
$dbuser="edpudol";
$dbpass="edpudol.com";

that's all and all set
edpudol is offline
Reply With Quote
View Public Profile Visit edpudol's homepage!
 
Old 10-01-2007, 12:47 PM Re: How to set up a database to a site pls help
Skilled Talker

Posts: 96
Name: james belcher
Hi there

Im on Go Daddy and looking through some old posts on the net. They do not host the database at local host. I asked the support there if they can see whats wrong with the site and they seem to think its working. I need to send them another support ticket I think.

Thanks

James
James B is offline
Reply With Quote
View Public Profile
 
Old 10-01-2007, 11:24 PM Re: How to set up a database to a site pls help
Novice Talker

Posts: 7
James, your database path will be something like mysql222.secureserver.net, it's not localhost.

Go to godaddy and go to your sql databases are go to the database in question and check the details. It will list your username, pass and your database path.
GNR08 is offline
Reply With Quote
View Public Profile
 
Old 10-02-2007, 01:39 AM Re: How to set up a database to a site pls help
King Spam Talker

Posts: 1,069
James, Did you create a database in your hosting control panel?

If you did it told you the host name at that time. If you did the info can still be retrieved from the control panel.

If you did not that is the problem.
colbyt is offline
Reply With Quote
View Public Profile
 
Old 10-02-2007, 02:41 PM Re: How to set up a database to a site pls help
Skilled Talker

Posts: 96
Name: james belcher
I think Im just going to move it to another account.

One person at Go Daddy said there is nothing wrong with the site. Idiot! The second person told me how to look up the host name like you helpful guys have on here.

Still not working. I will continue to have a play tonight. If it dont work I will just host it at another place.

I hate trying to do new things. They never work for me and Im sure its something stupid Im doing wrong.

This is the problem Im getting

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/content/y/o/u/**********/html/randomrecipes.php on line 7
Access denied for user '*******'@'p3slh087.shr.phx3.secureserver.net' (using password: NO)

I took out my account name for security.

Thanks

James

Last edited by James B : 10-02-2007 at 02:42 PM.
James B is offline
Reply With Quote
View Public Profile
 
Old 10-02-2007, 09:44 PM Re: How to set up a database to a site pls help
Novice Talker

Posts: 7
Ok I know whats wrong. I'm going to bed right now and really tired but in the morning I can help you.

it starts with /home ... right?

I'll look it up in the morning k.
GNR08 is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to How to set up a database to a site pls help
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.17090 seconds with 13 queries