Additionally to all great advice above, I would empty the cache just before dumping the database. <br><br>When setting up a new mysql installation, it is useful in the long run to make sure that the default character setting is uft-8. I wrote a tutorial about that a while ago, because I ran into issues with the feed aggregator: <a href="http://upsitesweb.com/blog/2011/08/drupal-7-feed-aggregator-issue-mysql-character-set">http://upsitesweb.com/blog/2011/08/drupal-7-feed-aggregator-issue-mysql-character-set</a><br>
<br>Ursula<br><br><br><div class="gmail_quote">On Sat, Oct 8, 2011 at 9:00 AM, Ms. Nancy Wichmann <span dir="ltr"><<a href="mailto:nan_wich@bellsouth.net">nan_wich@bellsouth.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div style="color:#000;background-color:#fff;font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:10pt"><div><span><font style="font-family:arial,helvetica,sans-serif" size="3"><span>The first step should always be to ask </span></font><font size="3"><span style="font-family:arial,helvetica,sans-serif">the new host if they will do it. Many will do it for free.</span></font><br>
</span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><b>Nancy</b></i></font></div> <div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div>
<div><br><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px"><div style="font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:10pt"><div style="font-family:times new roman, new york, times, serif;font-size:12pt">
<font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold">From:</span></b> James Rome<br></font><div class="im"><br>
I need to move my sites to a new host. What is the procedure for doing<br>this, especially the backup and restore of the database? Does the<br>hosting-specific information reside inside the database? If so, how do I<br>change them? The page URLs will not be changed.<br>
</div></div></div></blockquote></div></div></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>