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