<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
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 class="moz-txt-link-abbreviated" 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>
<em class="placeholder">Notice</em>: unserialize(): Error at offset
27410 of 57720 bytes in <em class="placeholder">DrupalDatabaseCache->prepareItem()</em>
(line <em class="placeholder">401</em> of <em class="placeholder">/home/user1/drupal-7.0/includes/cache.inc</em>).<br>
<br>
<em class="placeholder"></em><em class="placeholder">PDOException</em>:
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 <em class="placeholder">menu_get_item()</em> (line <em
class="placeholder">443</em> of <em class="placeholder">/home/user1/pmi/drupal-7.0/includes/menu.inc</em>).<br>
<br>
Similar to <a class="moz-txt-link-freetext" 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>
</body>
</html>