Log in

View Full Version : [Tut] Domain, FTP, and MySQL tutorial



beer
21-02-2007, 12:58 PM
Note that this tutorial presumes you already have a hosting account. I personally recommend www.crisphosting.net

Domain

Right once you have your hosting account, you will need a domain. I recommend www.123-reg.co.uk. I won’t take you through the billing process as that’s easy enough to figure out. Once you have bought your domain, go to the homepage and click log into your control panel. You will be presented with this just simply tap in your user name and password that got sent to you in your email then hit your enter button or click ok:
http://clubbinghabbos.net/imagehosting/images/bwy1172061647g.PNG

You will be presented with something that looks like this. Scroll down and find your domain(s) and select the one you want then hit the modify domain button:
http://clubbinghabbos.net/imagehosting/images/klz1172061722s.PNG

You will get something that looks like this. Scroll down and select the link that says change nameservers:
http://clubbinghabbos.net/imagehosting/images/rgh1172061764j.PNG

In the email that got sent from your hosting, you will have got 2 nameservers to enter into your domain account. Enter them into the 2 boxes as shown below then hit the change nameservers button then go back to control panel:
http://clubbinghabbos.net/imagehosting/images/arx1172061814i.PNG

You now need to select the link that says manage DNS:
http://clubbinghabbos.net/imagehosting/images/rgh1172061764j.PNG

You will be presented with something like this. In the two boxes where you can see 66.79.167.236 (my hosting’s ip address), input the IP address you got from your hosting account. Then scroll down a bit and hit the update DNS button. Then all you have to do is wait for the domain to be pointed to your hosting account and that’s it. Hit log out at the top:
http://clubbinghabbos.net/imagehosting/images/bfi1172061911i.PNG

FTP

First of all, you will need an FTP client. I personally recommend SmartFTP from www.smartftp.com (you should know how to download & install by now). Once installed, open it and in the 3 boxes at the top put your domain in the address box, your hosting accounts username in the Login box and your password in the password box. In the port box put 21 if it doesn’t already have it. Then hit the little green “Go” button. You will get something that looks like this:
http://clubbinghabbos.net/imagehosting/images/viu1172062000q.PNG

To the right of the window, there is a list of folders as you can see. There should either be a public_html folder or a www folder. This is where your website files need to go. Just simply go to the folder that you store your website files in, hit ctrl+a to select them all then drag them into smart ftp then hover over the public_html/www folder and release the mouse button. Your files will begin uploading. Once done you should see a list of files in your public_html/www folder like this Note that if you have both public_html and www, upload to public_html:
http://clubbinghabbos.net/imagehosting/images/bwy1172062068b.PNG

You should then be able to go to your domain in your web browser and view your site for yourself. Note that your main page (the one you want visitors to see first) MUST be called index this is how the domain finds your site. If it isn’t called index, all your visitors will see is a list of files and be very confused.

MySQL

Right you have probably had your site for a while and want to add some automated php scripts like a DJ panel or something similar. Scripts like this use MySQL as their database engine to store DJs etc. To make a new MySQL database, first log into your cpanel by going to www.yoursite.com/cpanel (may not work an all hosting accounts. You may need to log in via your hosting domain i.e. www.myhosting.com/cpanel) You simply input the username and password you got with your hosting account. You will get something that looks like this. Click on MySQL Databases:
http://clubbinghabbos.net/imagehosting/images/viu1172062146g.PNG

You will then get something that looks like this. To make your new database, simply type a database name into the box where it says new database and click “create database”. You will get a confirmation message simply click go back when u get it:
http://clubbinghabbos.net/imagehosting/images/bwy1172062365f.PNG

Now, some php scripts come with install files to execute MySQL queries automatically but you will either need to edit the config file which will be something like config.php or input database details half way through the install script. Here is what config.php should look like note that I have put the username before the database name. This is required otherwise your script wont work. This also counts for install scripts. Host is localhost, username is your hosting account username, password is your hosting accounts password and database name is your username_databasename. If there is a table prefix, leave it at its default.:
http://clubbinghabbos.net/imagehosting/images/bfi1172062474i.PNG

If however your script doesn’t come with an install file but a SQL file, you will need to execute the SQL query via phpmyadmin. To do this, scroll to the bottom of the databases screen in cpanel and click phpMyAdmin. You will get this screen. Select the database you just created from the drop down list on the left:
http://clubbinghabbos.net/imagehosting/images/klz1172062520h.PNG

You will get this screen. See the little link highlighted in blue that says SQL on it and query window under it? Click it:
http://clubbinghabbos.net/imagehosting/images/bwy1172062583w.PNG

You will get this. Paste the SQL from your SQL file into the window then hit the Go button:
http://clubbinghabbos.net/imagehosting/images/jdv1172062632n.PNG

You will then see a list down the left hand side of the page. This means that the query has been executed successfully and presuming you have uploaded your script files, you should now be able to use it. Enjoy!:
http://clubbinghabbos.net/imagehosting/images/bfi1172062683m.PNG

This tutorial was created By Lee Bentley. No attempts should be made to copy, re-distribute or edit without my permission. Thanks.

Isolde
21-02-2007, 01:08 PM
Nice tutorial, very helpful. I like. +rep.

beer
21-02-2007, 01:15 PM
Thanks :]

Isolde
21-02-2007, 01:18 PM
No problem =] This should get stickied, very helpful.

-::Mr.Dave::-
21-02-2007, 01:21 PM
can u provide a DJ Panel

Isolde
21-02-2007, 01:31 PM
Get those free from Giantdevs.

beer
21-02-2007, 02:00 PM
yeah you can www.giantdevs.co.nr (http://www.giantdevs.co.nr)


or u used to be able to lol

Blob
21-02-2007, 02:07 PM
yeah you can www.giantdevs.co.nr (http://www.giantdevs.co.nr)


or u used to be able to lol

www.radioscripts.co.nr

Drompo
21-02-2007, 02:14 PM
Good TUT, MySQL doesn't go in to much depth as its it basicly just showing how you run a query. But 8/10

beer
21-02-2007, 02:43 PM
lol thanks ash :rolleyes:

beer
21-02-2007, 09:12 PM
bumpety bump :]

Isolde
21-02-2007, 09:25 PM
ban please. xD

F32
21-02-2007, 09:32 PM
ban please. xD
spam please. :P

nice tut.

Isolde
21-02-2007, 09:37 PM
shhh please =]

I'm requesting this to get stickied, it's really good and i've said this before.

beer
22-02-2007, 02:03 PM
or moved to tuts?

Blob
22-02-2007, 02:08 PM
They wont stickie it, they will move it.

Want to hide these adverts? Register an account for free!