[support] Copying a site

[Iain Wiseman]

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





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110910/e328e316/attachment.html