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