Public Forums 71,145 posts

[pjed Friend pjedJoin date: May 2008Posts: 10Downloads:0Uploads:2 Thanks: 2]

#129024

Hello,
I am working on my site’s structure and content using wampserver (localhost)
I realize that all of the content (and other items: ie menus) get stored in Mysql.
Is there a way so that when I am ready to “go live” I can export to my server (Linux based, PHP5, Cpanel 11) all of my website’s content and structure.
Basicaly, upload the quickstart.zip file to my sever, extract it, set up DB (using Cpanel) then extract the template. Then I need a way to remove sample data and change it with the localhost site that i’ve created.

Thanks,

Philip (Complete NEWBIE)

[Menalto Friend MenaltoJoin date: May 2007Posts: 4736Downloads:0Uploads:43 Thanks: 2 Thanked: 531 times in 361 posts]

#250995

When you are ready to go live you can just ftp all files from localhost to your webserver.
Then do a backup of the database you have on localhost and import it using phpmyadmin or similar database tools you have available.
When thats done you need to open up the configuration.php file and fill in the parameters you need such as databae name, user, pass etc.

[pjed Friend pjedJoin date: May 2008Posts: 10Downloads:0Uploads:2 Thanks: 2]

#251005

Hey Thanks for the quick reply.
Just ran a test, and made a few mods to your instructions and it worked like a charm.
exported localhost.sql and livedb.sql both to my desktop, took info from localhost.sql and pasted in livedb.sql (with top databse part left intact) then via php admin on my sever, imported the modified dtabase (with same name and settings) back on to the server (had to erase “old db” first, yes, made b/u)
And it worked perfectly, did not have to modify config file 😀
This a great way to work offline and then when your ready, just swap database.

Again, thanks for your help.

Cheers,

Philip

[Author]

Posts