Uploading my site to my ISP

[Hyper]

Hello All

I currently run www.northernrc.com and want to move it to my isp's server as they provide me with 250mb web space. This includes 1 mysql database.

So i have made a backup of my current mysql database and its a gzip file but i havent got a clue on how to upload it to the plusnet server.

I go into my website settings inside the plusnet control panel and click on mysql and get phpmyadmin (dont have a clue how to use this)

Look at the attached file to see what i see.

Also plusnet give you a guide of how to use it but even though i have been hosting websites for nearly a year now this is totally new to me.

Take a look

If anyone can explain to me how i will get my full site onto there servers i would be very happy

Thanks Sam

 

[FragTek]

Tiz quite easy mate, just download your entire site to your computer, login to your new servers FTP and then upload it all.

 

[Hyper]

Tiz quite easy mate, just download your entire site to your computer, login to your new servers FTP and then upload it all.

What about the mysql database though?

 

[FragTek]

What about the mysql database though?

Does your new host use cPanel?

 

[Hyper]

Does your new host use cPanel?

My old host did.

I am now moving all the files to plusnet who just use there own crappy control panel.

 

[FragTek]

Hrmmm that sucks, the only way I could help you would be throuch cpanel as I know my way around it pretty darn well.

What you need is Jim or Dave's expert advice, they can probably get you up and running in no time at all.

Cheers.

 

[Hyper]

Well if either of them read this then could they please help me

Thanks Alot.

Sam

 

[Tec]

Well you need to activate your mysql from control panel > website settings.

Although i dont have plusnet account i have managed to login with my old details and i cant see that option there. Maybe its because of my account type ( pay and go )

Once you enable mysql you should receive an auto email with mysql details.

Their usual mysql server was rumpus

login name = username

databasename = username_pn e.g username_pn

password= auto generated when u activate your mysql.

You should upload your mysql file to your server root and ask them to import the data to your database, this is the best option and time saving otherwise depending on your database size you will need to create multi parts file as php might timeout , or it used usually time out when i used plusnet.

Make sure your tables and data are in a txt file and save it as filename.sql

select your database from phpmyadmin, on the right you ll see SQL on the menu. when you click on it it has 2 section , 1 section for quick commands and another for file , click browse then browse to your file and that should do it. Like i said if page timeouts divide your file in multiple files and import them 1 by 1. or eventually you can copy and paste into quick command box and apply part by part.

 

[FragTek]

Reps for Tec... Nice mate

 

[Hyper]

Yep, Thanks alot Tec.

Will have a go tomorrow.

 

[Hyper]

Thanks for the help so far lads.

I have uploaded the forum to the server but it doesnt appear to be working using the temporary sub domain they gave me to test it:

www.samgarratt.plus.com/forum

The server doesnt seem to reconise php.

Why is this?

 

[Tec]

You also need to activate cgi same way in website settings

 

[Hyper]

You also need to activate cgi same way in website settings

I have done and got a e-mail saying it was activated last night

 

[Hyper]

E-Mail sent to Tec