Just a quick tip, for convenience, make two DB dumps: one with the table schemas, and one with the actual data excluding the data from the cache, watchdog, and sessions tables.<div><br></div><div>Regards,</div><div><br></div>
<div>Bit Santos</div><div>Senior Web Developer</div><div>Spinweb Productions, Inc.<br><div><br><div class="gmail_quote">On Mon, Oct 12, 2009 at 10:45 AM, 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;">I move back and forth between Linux and Windows frequently; occasionally I<br>
have trouble when the database is in a compressed state (usually zip form).<br>
I have never had a problem when the database was not compressed. So the<br>
first thing I do before moving is to TRUNCATE all the cache files, watchdog,<br>
and sessions tables, and OPTIMIZE any tables with overhead. If that gets me<br>
below the maximum upload size, then I do not compress the data. If I have to<br>
compress the data I do it more than once, a few minutes apart.<br>
<br>
Nancy E. Wichmann, PMP<br>
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,<br>
Jr.<br>
<div><div></div><div class="h5"><br>
_______________________________________________<br>
consulting mailing list<br>
<a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
</div></div></blockquote></div><br></div></div>