Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



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

Posts: 98
Name: james belcher
Trades: 0
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
__________________

Please login or register to view this content. Registration is FREE
James B is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 09-30-2007, 07:08 AM Re: How to set up a database to a site pls help
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
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!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 09-30-2007, 08:44 AM Re: How to set up a database to a site pls help
Skilled Talker

Posts: 98
Name: james belcher
Trades: 0
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
__________________

Please login or register to view this content. Registration is FREE
James B is offline
Reply With Quote
View Public Profile
 
Old 09-30-2007, 02:31 PM Re: How to set up a database to a site pls help
edpudol's Avatar
Super Spam Talker

Posts: 913
Trades: 3
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
__________________

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE



Please login or register to view this content. Registration is FREE
edpudol is offline
Reply With Quote
View Public Profile Visit edpudol's homepage!
 
Old 10-01-2007, 01:47 PM Re: How to set up a database to a site pls help
Skilled Talker

Posts: 98
Name: james belcher
Trades: 0
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
__________________

Please login or register to view this content. Registration is FREE
James B is offline
Reply With Quote
View Public Profile
 
Old 10-02-2007, 12:24 AM Re: How to set up a database to a site pls help
Novice Talker

Posts: 7
Trades: 0
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, 02:39 AM Re: How to set up a database to a site pls help
Defies a Status

Posts: 1,605
Trades: 0
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

Please login or register to view this content. Registration is FREE
colbyt is offline
Reply With Quote
View Public Profile
 
Old 10-02-2007, 03:41 PM Re: How to set up a database to a site pls help
Skilled Talker

Posts: 98
Name: james belcher
Trades: 0
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
__________________

Please login or register to view this content. Registration is FREE

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

Posts: 7
Trades: 0
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 Search this Thread
Search this Thread:

Advanced Search

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

BB 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.29926 seconds with 12 queries