Hi,
I have done this before but I seem to be struggling to get this to work.
My approach is - export DB - cp directory - search for old machine www.foo.com and replace with new site - tar directory up - copy both to new machine - untar directory on new machine - create DB on new machine - create user on new machine - import mysql -u root -p <DB> <dump.sql
However have the error
/Notice/: unserialize(): Error at offset 27410 of 57720 bytes in /DrupalDatabaseCache->prepareItem()/ (line /401/ of //home/user1/drupal-7.0/includes/cache.inc/).
///PDOException/: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1: SELECT * FROM {menu_router} WHERE path IN () ORDER BY fit DESC LIMIT 0, 1; Array ( ) in /menu_get_item()/ (line /443/ of //home/user1/pmi/drupal-7.0/includes/menu.inc/).
Similar to http://drupal.org/node/1114304
Any ideas. Thanks, Iain