Best way to move drupal from localhost to remote server

neroflick - March 27, 2009 - 17:11

Hello guys,

I just moved my drupal files/folders from localhost to live server. I have also imported the database and made the connections in settings.php. However, pointing to my site home gives an HTTP 500 Internal Server error. The only pages i can access are:

www.missotown.com/contact
www.missotown.com/forum

Pls guys, is there anything am missing? What's the proper way to move drupal to a live server?

Thanks

Waiting for help ...

neroflick - March 27, 2009 - 17:45

Waiting for help ...

=-=

VM - March 27, 2009 - 17:48

bumping your thread after 30 minutes isn't helpful.

did you clear all the cache tables in the database?

sorry about the bumping

neroflick - March 27, 2009 - 18:08

sorry about the bumping ....

no i didn't, infact am just hearing that for the first time. could u pls outline the entire process step-wise? many thanks!

How to empty

blueflowers - March 27, 2009 - 18:15

How to empty cache:

http://drupal.org/node/42055

Fourth Wall Media
Toronto, Canada

=-=

VM - March 27, 2009 - 18:18

I don't know that I'd use the snippet used in that document. First off the document is deprecated second, there is more than one cache table in drupal 6.x which includes menu cache.

to clear your cache tables manually
use phpmyadmin or like tool
locate the tables and empty them.

Typically I do this before I export the database to be moved.

I stand corrected! Thanks

blueflowers - March 27, 2009 - 18:36

I stand corrected! Thanks VeryMisunderstood. The cache tables will look something like:

cache_tablename depending on your install and which modules you have also installed.

Fourth Wall Media
Toronto, Canada

def clear your cache table as

blueflowers - March 27, 2009 - 18:08

def clear your cache table as pointed out by VeryMisunderstood.

Also might be helpful to uncomment this line in your .htaccess file

RewriteBase /

Fourth Wall Media
Toronto, Canada

So wat are the step?

neroflick - March 27, 2009 - 18:37

Thanks guys but if i get u right, all i need do is

1. Clear cache tables
2. Export db and then import on live server
3. Move files/folders to live server
4. Edit settings.php to reflect live server config

Are these all i need to do?

yes, that should do it.

blueflowers - March 27, 2009 - 18:45

yes, that should do it. also, make sure php5 is running. You can do that by adding this line to your .htaccess file

AddType x-mapp-php5 .php

if for some reason at this point your homepage shows but no other pages, then do my suggestion of uncommenting this line in htaccess

RewriteBase /

Fourth Wall Media
Toronto, Canada

Tried it but it didn't work

neroflick - March 27, 2009 - 19:06

Guys, i've tried everything here but it didn't work. Could you guys pls lead me from the scratch without assuming anything as am a complete noob in drupal.

I got a drupal website running fine in localhost. I want to move it to a live server. How do i begin? Do i need to disable anything locally, disable any modules or stuffs like that. Pls guys .... be very detailed with and also forgive my ignorance.

Thanks y'all ...

I'm at a loss. Who is your

blueflowers - March 27, 2009 - 19:26

I'm at a loss. Who is your hosting company? It may be a problem on that end. Are you able to do a fresh install of Drupal on your live server w/o a 500 error?

Fourth Wall Media
Toronto, Canada

Thanks again

neroflick - March 28, 2009 - 10:31

I have a dedicated server at Rackspace on which i host several php scripts ...

I'd try the fresh install on live server and see how it goes ...

You still didn't outline the transfer procedure ... would really appreciate if u can.

Beware of differences like

916Designs - March 27, 2009 - 19:54

Beware of differences like your local site being in your htdocs folder and your live site being in htdocs/drupalsite. It does sound like your host's php config is off.

Am a drupal noob but i aint

neroflick - March 28, 2009 - 10:35

Am a drupal noob but i aint new to installing php scripts. I come from a joomla background where there is concrete documentation for this sort of transfer. As regards my php config, its okay as i have other scripts running on my server.

All i need really now is the RIGHT procedure (outlined in the correct sequence without any assumptions) to transfer a drupal site from local site to live server.

Thanks for your support .... I really appreciate!!!

=-=

VM - March 28, 2009 - 18:07

I ...

put mysite in offline mode.
I clear all cache tables, the watchdog table, and the sessions table
I export the databse

I import the database to the new DB
I move the files
I open and adjust settings.php, $db_url to point to the new database and adjust mysqli or mysql to what it needs to be based on the version of PHP running.

I put the site back online

I navigate the site

I'm done.

Thanks Y'all

neroflick - March 29, 2009 - 09:55

Got it right at last! Thanks for all the tips ... I really appreciate u guys.

"Concrete documentation for transfer"

meh - October 26, 2009 - 23:20

You're right ... there is a palpable lack of teaching 'empathy' within the Drupal community.

How can it be that there is not an architecturally-oriented published "How-to" document about this!

multi-site mode

remy.damour - June 15, 2009 - 19:00

Hi, If you're on multi-site mode, you will also need to rename you subsites folders to match domain names.

(ex: /drupal/sites/site1.localhost should be renamed into /drupal/sites/site1.mydomain.com)

you might need to update 'filepath' column in 'files' db table

remy.damour - June 18, 2009 - 09:48

when setting up live a multi-site drupal installation, you might need to update 'filepath' column in 'files' db table too!
Otherwise documents/images might not show up and still point to localhost.

More info: http://www.qc4blog.com/?p=714

 
 

Drupal is a registered trademark of Dries Buytaert.