[support] Copying a site

[Steve Kessler]

Did you try clearing your cache before dumping the DB?
On Sep 9, 2011 9:58 PM, "Iain Wiseman" <iwiseman at 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
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110909/b5a857a0/attachment-0001.html