Local host to remote host

[dchamai]

Hi, I'm relatively new in websites and have been searching through old threads to see if there's is any answer to my question but havent found one so please bare with me.

I've created my website using dreamweaver and using XAMPP as a local host so i can test the php/mysql stuff on my laptop. Now i plan to move my website online as part of my project testing site so i can let other people view the site and test it.

What im confused about is do I upload just the pages of the site?? What about the php/mysql files in the XAMPP folder or does x10 sever has all this? I can use FTP using dreamweaver to upload my files, would there be anything i need to edit/do in the cPanel to get the php/mysql running? I have created tables already on the local host and how would i move this to the online site?

Thanks for any feedback.

 

[kajasweb]

You can Export the Structure / Data from your MySQL Database through phpMyAdmin & Import it here.

 

[dchamai]

hi thanks, do u mean the phpMyAdmine on the cpanel right on the site? It says i dont have no privileges to create a database? Oh so i export from my phpMyAdmin on my local host and import in phpMyAdmin on the cpanel site?

 

[kajasweb]

Create Databases from cPanel and import through phpMyAdmin.

 

[dchamai]

i created a database (however the database i had one my local site was called project_db but the one on the site could only be called dchamai_projectdb) and imported one of my tables, however when i load the main page, i get the error 'no database selected' ??
Any ideas? I think i have to select the new database for the site(using dreamwever) but what is the Mysql server root for my remote site? Before it as just localhost for my local site?

Thanks

 

[Chris73]

You must use the full DB name when trying to connect to that database. dchamai_projectdb would be the database name that you must have entered. Not just projectdb like you had.