I just run into problem of having a site under subdomain and moving it to live domain. Image paths in file table were all wrong, but there is simple fix for this.

UPDATE files SET filepath = REPLACE(filepath, 'old/path', 'new/path');

run this in phpmyadmin and chage paths completly, something like is what I used

Recently I was envolved with moving a site from one server (VPS) to other. I had to make a VPS installation also and setup of the server. I used Debian 6 which usually comes with php 5.3. Sometimes some modules have problems with 5.3 version of PHP.

Facebook-style Micropublisher works great with Facebook-style Statuses and is one of the coolest "new" drupal modules. Statuses are lightweight for database but statuses also can have their own page like nodes. Problem is that in my case this is not out of the box solution. So again i made some hacking :-)

Everything you need for this is here http://www.unleashed-technologies.com/blog/2010/07/16/drupal-6-insertin…

Few times i transfered online site to my localhost and site wouldnt work, no response form page. What i realized is that main problem were cache tables in database. After clearing them everything was fine. Best way to do that would be to use backup and migrate module and just select all cache tables to be emptied in advanced settings and then backup database and import it to your localhost.

Why drupaldump