<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>The Back_Migrate module has a setting for which tables to include only the structure. I would do that for all cache tables, sessions, and watchdog. Depending on what you use accesslog for, that one maybe. (Actually, I try to discourage accesslog use entirely.)<br></span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><strong>Nancy</strong></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: arial, helvetica, sans-serif; font-size: 12pt;"><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> Ursula Pieper<br></font><br>
<div id="yiv105392423">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: http://upsitesweb.com/blog/2011/08/drupal-7-feed-aggregator-issue-mysql-character-set<br></div></div></div></blockquote></div></div></body></html>