Did you try clearing your cache before dumping the DB? On Sep 9, 2011 9:58 PM, "Iain Wiseman" iwiseman@bibble.co.nz wrote:
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