Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba

From PC to Website (MySQL)


Go to End
Reply


4 Posts   1268 Views

Avatar
Beck

Community Member, 23 Posts

29 July 2009 at 5:01am

Hi everyone! till today i'm using WampServer. it's really good and usefull. but every time when i make a website. i have to make template, then other information i mean content i have to upload online(hosting). but i want to do it in my PC then upload it to website hosting.

How can i do this? How can i copy out MySQL from my PC to WebsiteHosting? or you know another way?

MY PC: Windows XP SP3
Website hosting: Linux or other except Windows

Thanks in advance

Avatar
banal

Community Member, 901 Posts

29 July 2009 at 9:48am

1) Create a new database on your Webhost (usually through some sort of control panel)
2) Dump your local database contents to a file (using PhpMyAdmin, the Backup function of the MySQL Administrator tool or command line)
3) Import the database dump into the database on your webserver
4) Copy all files from your PC to your webserver
5) Modify _config.php and .htaccess to reflect your webserver settings (update DB credentials and make sure RewriteBase in the .htaccess is correct)

I regularly copy local sites to webservers and it always worked like a charm. Oh and another thing:
6) On your production server, remove the error-404.html file from the assets folder and run dev/build?flush=all. This should recreate the cached files and the 404 error page (which may contain invalid links if you use the one from the local installation)

Avatar
Jennifer Banks

Community Member, 3 Posts

12 July 2011 at 2:47am

Thank you for your review, it was very helpful! I use http://www.serverintellect.com/ for my hosting and couldn't be happier.

Avatar
HamptonPearson

Community Member, 1 Post

13 July 2011 at 6:11pm

WampServer..is new for me...and i will convert my site...http://www.ceilingfansreviews.net/ ....for this server form..