Loading...


bookmark - Mysql Database Help need help with MySQL databases...skip to page three

Mysql Database Help - need help with MySQL databases...skip to page three

 
 Discussion by Dayzed with 48 Replies.
 Last Update: April 10, 2005, 6:57 pm (View Latest)
Page 1 of 2 pages.
bookmark - Mysql Database Help need help with MySQL databases...skip to page three  
Quickly Post to Mysql Database Help need help with MySQL databases...skip to page three w/o signup Share Info about Mysql Database Help need help with MySQL databases...skip to page three using Facebook, Twitter etc. email your friend about Mysql Database Help need help with MySQL databases...skip to page three Print
Reply / Comment New Discussion / Topic Share / Bookmark E-Mail a Friend Print


I just got hosted on Friday, and I just uploaded all the FTP files and SQL file. Now, I am losted at what to do. I thought since I uploaded all the files, it would work, but it doesnt. I am making a LUE2/OG-like site. You can help by posting a message here or emailing me or AIMing at mutatedmonkeycat. (AIM perfered..)









   Sun Apr 3, 2005    Reply         

So, it uses sql? Did you put it to the right adress a.k.a localhost (because it's hosted on trap's server). Btw, what is not working? What are the error messages? We need the details because it's like saying, my computer doesn't work, can you fix the problem. Details details...

   Mon Apr 4, 2005    Reply         

did you signup using gigapass.com like you said on your application?

1 you have not pointed your "DNS Record" nameservers to trap17 name servers yet. Until you do that I don't know how any of your data would be accessible. Your cpanel is accessible using the IP address only.

QUOTE

Your NS records at the parent servers are:

ns.kornet.net. [211.216.50.150] [TTL=172800] [KR]
ns2.kornet.net. [211.216.50.160] [TTL=172800] [KR]

[These were obtained from m.gtld-servers.net]


So until you update your NS record everything you do are in vain. :)

Nils







   Mon Apr 4, 2005    Reply         


There are no error messages, it just doesnt work. :\

I uploaded all the files, and when I try to go to my site afterwards (www.gigapass.trap17.com) it gets the "Welcome to your site!" thing. :\

NilsC, where do I put those numbers? >_>

   Fri Apr 8, 2005    Reply         

Also, what is the data base name?

   Fri Apr 8, 2005    Reply         

First, what folder did you upload your files to?
Next, your batabase name is USERNAME_ then the database name, er, at least I Think it is...

Also make sure that the index page is changed to be your index page not the index page that was on when you first got your account...

   Fri Apr 8, 2005    Reply         


QUOTE (Argoth)

First, what folder did you upload your files to?
Next, your batabase name is USERNAME_ then the database name, er, at least I Think it is...

Also make sure that the index page is changed to be your index page not the index page that was on when you first got your account...
view Post: 69855




Er, I uploaded the files to seperate files. There are about 50 of 'em. I still dont know what the database name is, would it be USERNAME_trap17 (so really it would be dayzed_trap17?)

How do you change the index page?

   Fri Apr 8, 2005    Reply         

Go to, Cpanel click on file manager, click on the folder next to "public_http", click on index.html then click edit on the right. A window will open with the code to the index page.

Make sure that the files you uploaded are in the public_http folder or you won't be able to access them.

You need to make a database before you can access it. To make a database go to cpanel, click on MySQL Databases, type whatever you want to call the database in the textbox and click "Create MySQL database". Then create a new user to access the database. Click on "go back", scroll down to where it says "Existing MySQL Users", type a name for the new user there and a password. Click "Create MySQL user".
Now allow the user to change the database. Click "go back", scroll to where it says " Grant permissions on a MySQL database to a MySQL user" and choose the user you made and the database you made. make sure "ALL" is clicked under privileges then click "Grant Permissions".

The database name is then the "YOURUSERNAME_YOURDATABASENAME" and then your username is "YOURCPANELUSERNAME_YOURDATABASEUSERNAME"

   Sat Apr 9, 2005    Reply         

I see no 'public_http.'

There is 'public_ftp' and 'public_html.' Thats it. :\

   Sat Apr 9, 2005    Reply         

public_html is the one you should look in

Answer me this...what is the name of the first webpage people will see when they go to yoursite? If it's not index.htm, index.html, or index.php, then rename it to any one of those three, and delete the existing index.html in your public_html folder in your cpanel.

   Sat Apr 9, 2005    Reply         

Okay, so I look in public_html?

The name of the first webpage is index.php.

   Sat Apr 9, 2005    Reply         

Okay, now, look in your public_html folder. You should see an index.html file. DELETE THAT!

Next, upload your index.php file to your public_html folder.

Keep posting if you need more. :)

   Sat Apr 9, 2005    Reply         

I think I got it! I have one more question before I procede, do I delete what is already in index.html (which I renamed to index.php), that states, "You wont do this, Welcome to your site, thank you, ect ect.'? Well, not delete, but remove it and place my code in its place...

   Sat Apr 9, 2005    Reply         

Ignore my last post...

   Sat Apr 9, 2005    Reply         

You can place your code in its (index.html) place, or you can delete index.html and upload your index.php file either way works because index.php takes precedence over the index.html file

   Sat Apr 9, 2005    Reply         

Okay, thanks.

But, there is a couple more problems, where do I upload the rest of my site script? In a seperate file? I have about 30 more files I need to upload, all of which are needed. Do I do it in a seperate file than index.php or in the same one? There is a footer that is needed on all pages and none of the site works without it.

And uh, since your helping, you still want an admin position correct? Or are you doing this out of the kindness of your heart?

   Sat Apr 9, 2005    Reply         

uploading all your files into the public_html folder should work. every file goes into your public_html folder.

being a moderator here is good enough :)

   Sat Apr 9, 2005    Reply         

Yeah, it probably is. When the slow as heck dial up allows me to uploade my files, I will tell you how it goes.

If you make me blow it up, its your fault... :)

   Sat Apr 9, 2005    Reply         

Also, I have a file called sql.sql. Do I put it in the same place?

   Sat Apr 9, 2005    Reply         

It all depends. If you call sql.sql using an absolute link, then it shouldn't matter where you put it, but if you call it using a relative link, then you have to put it in the correct folder.

How do you call it in another file?

   Sat Apr 9, 2005    Reply         

Whats an absolute link?



Okay, okay, I lied, not the last question....

   Sat Apr 9, 2005    Reply         

Absolute is where you call your sql.sql file using the full path.

CODE


<?php
include("http://blah.trap17.com/sql.sql");
?>

^ That's an example of an absolute call in PHP

CODE


<?php
include("sql.sql");
?>

^ That's relative, and it will work ONLY if the calling file is in the same directory or folder as the sql.sql file.

   Sat Apr 9, 2005    Reply         

I think I get what your saying, not sure though.


I tried moving it around, all over the place, and an error message comes up. Go to here to figure out what I'm talking about:

www.gigapass.trap17.com

I dont know what is wrong. I triple checked everything, and it seems to be correct....

   Sat Apr 9, 2005    Reply         

Well, I have 0 experience with MySQL because I find it to be unreliable - PHP never goes down.

What's the content of you config.inc.php file? Post the entire code (if it's not large) here

   Sat Apr 9, 2005    Reply         

CODE

<?php
$_CONFIG['mbname']    = '';    // Giga Pass
$_CONFIG['mbsurl']     = '';    // [url=http://gigapass.trap17.com]http://gigapass.trap17.com[/url]
$_CONFIG['dbhost']    = '';    // trap17.com
$_CONFIG['homepage']   = '';    // [url=http://gigapass.trap17.com]http://gigapass.trap17.com[/url]
$_CONFIG['legal_tags'] = 'b|i'; // HTML tags allowed in messages. You can only add tags that have no attributes.
$_MYSQL['dbhost']      = '';    // localhost
$_MYSQL['dbuser']      = '';    // dayzed_ejashby
$_MYSQL['dbpass']      = '';    // (I put the password for dayzed_ejashby here)
$_MYSQL['dbname']      = '';    // dayzed_SQLdatabase

//
// User level definitions
//

define('Inactive', 0);
define('Warned', 1);
define('Mutie', 12);
define('Rookie', 15);
define('Veteran', 18);
define('Idol', 30);
define('Moderator', 52);
define('Administrator', 60);

//
// Include money (Coins) configuration. Go edit that file.
//

require 'mny_config.php';

$db = @mysql_connect($_MYSQL['localhost'], $_MYSQL['dayzed_ejashby'], $_MYSQL['(password for dayzed_ejashby)'])
or die("<b>Error:</b> Failed to connect to database host: {$_MYSQL['localhost']}<br />
       <b>Possible Solution:</b> Check if the database host name, user name and password are defined
       correctly in the config.inc.php file.<br />
       <b>MySQL says:</b> ". mysql_error());

@mysql_select_db($_MYSQL['dayzed_sqldatabase'], $db)
or die("<b>Error:</b> Failed to select database: {$_MYSQL['dayzed_sqldatabase']}<br />
       <b>Possible Solution:</b> Check if the database is set up and the database name
       defined in the config.inc.php file is correct.<br />
       <b>MySQL says:</b> ". mysql_error());
?>

Where my password is supposed to be, I have my password, not the text.

[note=snlildude87]Placing your code in

CODE

BBCodes makes it so much easier to read[/note]

   Sat Apr 9, 2005    Reply         

Hmm, did you put mny_config.php (as well as every other files) in your public_html folder? If you did, then I don't know where to go from here because I have not worked with MySQL... :)

   Sat Apr 9, 2005    Reply         

Yes I did....


*cries*


So you can't help me anymore? Do you know anyone who can?

   Sat Apr 9, 2005    Reply         

I can help you one last time: by changing the thread title to make it look more appealing.

   Sat Apr 9, 2005    Reply         

I cant edit it, and if I can I dont know how.

   Sat Apr 9, 2005    Reply         

Oh, thanks. I thought you ment me....

   Sat Apr 9, 2005    Reply         

Quickly Post to Mysql Database Help need help with MySQL databases...skip to page three w/o signup Share Info about Mysql Database Help need help with MySQL databases...skip to page three using Facebook, Twitter etc. email your friend about Mysql Database Help need help with MySQL databases...skip to page three Print
Reply / Comment New Discussion / Topic Share / Bookmark E-Mail a Friend Print


Similar Topics:

Need Advice On Setting Up Mysql Dat...

First of all, to get the idea of what I am trying to achieve here, please have a look at my idea thread, entitled Idea For ...more

   22-Aug-2008    Reply         

All Databases Down Now

Hi, Currently, as for past 50-60 minutes, all MySQL databases are down. Ticket ID: NRY-328984 Normally - I do not open a thread here when there is a problem. I just raise a ticket. But there is a cause of concern for me at this point in time. One thing is that I have ...more

   21-Jan-2010    Reply         

Using Data From 2 Databases

I use a great piece of software (it is even free) called QIOS Pelican to send out newsletters. It is compatible with a number of different datasources (MySQL, Access, Oracle, Excel, Outlook address book etc.), and then sends out your email (which you can also edit in the program) to the recipi ...more

   13-Mar-2011    Reply         

Cpanel Isn't Working?    Cpanel Isn't Working? (1) (7) When I Added A Parked Domain...   When I Added A Parked Domain...