From WAMP to web server
Sorry I couldn't join everyone tonight for the Madison group.
I'm building a site in Drupal and started on my local computer with WAMP Server. Now I need to move things to a real web server, and I don't want to start over from scratch.
Any suggestions on the best way to do this? I've got the Using Drupal book, but didn't find anything in there about it.
Thanks,
Reid Magney
Wisconsin Government Accountability Board
gab.wi.gov (not Drupal yet, but coming soon)
Ical feed
backup and migrate mod
http://drupal.org/project/backup_migrate
This module makes it easy to export your database and import to another server. Zip up your drupal directory and upload to your new server and adjust the settings.php file to connect to the new database and you should be good to go.
Thanks
I appreciate your help!
mysqldump and tar/zip
If you're running on a Linux/Unix box, the easiest way I've found is to first dump the database into a .sql file in the web tree, then zip/tar.gz the whole web tree. Copy it to the production server, unzip and reimport the DB. I can launch a site this way in under 5 minutes.
If you're running windows, you probably also have mysqldump (command line)
mysqldump -uUSERNAME -pPASSWORD DATABASE > WEBROOT/DATABASE.sql
tar cvzf WEBROOT.tar.gz WEBROOT
copy WEBROOT.tar.gz to the destination server and unzip it.
Then on the other end, re-import your database
mysql -uUSERNAME -pPASSWORD DATABASE < DATABASE.sql
Make sure to reset permissions on the tree to match the prod server, and add world-write to your /sites/all/files directory, and you're good to go.
I've used phpmyadmin to export/import in the past, but 90% of the time, the character encoding gets borked, which either makes the site not load, or causes a bunch ofweird characters to appear in the content. Mysqldump seems to be the quickest and most reliable way to manually import/export the dumps.
That's how I do it anyway. I might have to check out this backup_migrate module when I need to do this next.
Thank you
I appreciate your advice.
Right now I'm developing on WAMPserver 2, but moving to a Linux box.
It's not too difficult now
After numerous trial and error, I think I've gotten this process down fairly well migrating a local WAMP site to a live server.
In WAMP, go to phpmyadmin find your database -> click on privileges -> then add an additional username and password with "granted all privileges" on localhost server for that database
On your live webserver create a MySQL database with the same name as your localhost database
-add the same new username and password as in step 1
-associate the new username and "grant all privileges" for the new database
Check consistency of clean URLs (I've done this a few times the WRONG way)
-if your WAMP ocalhost site has clean URLs enabled - make sure to DISABLE CLEAN URLS, just for now
Go back to WAMP localhost site phpmyadmin -> select the database you're migrating -> click the export tab -> highlight "sql file" and click go
FTP transfer the latest version of Drupal Core -> FTP transfer your WAMP /sites folder into the fresh install /sites folder on the webserver, overwriting everything inside the /sites on the webserver.
On the live webserver, go into phpmyadmin -> select the database your created in step 2 -> click the import tab -> browse to find the exported WAMP sql file in your computer -> click go
That should be it! Since the WAMP and webserver databases have the same name, same username and password with all privileges, there is no need to alter the settings.php file. If you need more assistance send me a message because I am local in Madison, WI.