Evening All,

 

I have created a MySql database with my website and now its all working I would like export it from localhost to my server.

 

How do I do it? can't really find any tutorials... I'm using WAMP

Open up phpMyAdmin, you'll find export options in there.

Thats what I thought but I keep on getting an error say there is something wrong with my php, let me try again and I'll post what is says

phpmyadmin > go to database page (where tables are displayed) > export > ensure all tables are selected, go to bottom and make sure "Save as file" IS NOT selected > click "Go"

 

You will get a text box with a load of mysql stuff in. Copy the entire contents of the text box, save in a text file if you need to.

 

To import the data:

 

Create a new database (name it whatever you want) > go to page where tables would be displayed (if you had any) > Click "SQL" tab > paste the text which you previously copied into the text box > click go

 

What this basically does is to run all of the sql queries neede to create the DB tables.

 

Sorry if thats a little complicated. There is a way to do it where you save the .sql file but i prefer my way (alot easier when you get the hang of it).

Ok yep thats worked thanks... ok I now have another small question...

 

How do connect to my webserver?

 

Everything is on localhost on my PC now I want to upload everything to the site. All files are on waiting but how do I connect to the sever and create my databases on there????

 

 

Sorry if its a silly question

To create the databases, you will have to use the import or "SQL" features within phpMyAdmin on your server. Your host should have provided you a link to get to it. You will most likely have to go through a control panel or some sort (may be called cPanel or Plesk).

 

To upload the files, you will need to use an FTP client such as FileZilla. Again, your FTP details should have been provided by your host.

 

Good luck

I have found a cpanel on the file list on filezilla.

 

The problem is I don't know who the host is or any login details for the host. I only have the FTP details....

cPanel is usually accessed via a port number which varies through different hosts so it would be http://yoururl.com:833 or something similar. You will most likely have to contact the host.

 

I'm not sure how you would find out who the host is. You could try a WHOIS Lookup for the domain name but it's hit and miss whether the host name is included.

Do a whois on the domain, go down to where it says "Server Data" and click the "Whois" link next to the IP address. There should be some addtional info on there about who owns the IP.

cPanel is usually accessed via a port number which varies through different hosts so it would be http://yoururl.com:833 or something similar. You will most likely have to contact the host.

 

I'm not sure how you would find out who the host is. You could try a WHOIS Lookup for the domain name but it's hit and miss whether the host name is included.

 

ArHa Your right... thanks very much!!!!