Hi,<br><br><div class="gmail_quote">On Wed, Aug 12, 2009 at 9:29 AM, Ogure Obunga <span dir="ltr">&lt;<a href="mailto:write2ogush@gmail.com">write2ogush@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Problem: I&#39;m trying to import a large mysql dumpfile to a new server (localhost). The file is larger (16mb) than the allowed maximum_file_size as specified in my.ini (1mb).</blockquote><div>Checked  max_allowed_packet ?<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> I have tried using bigdump, and other tricks including changing the settings of my.ini without much success.</blockquote>
<div> Chunk it then.. Split the selects into batches. Or better,  try using load data?</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
 I run on Wamp server 2.0i<br>
<br>Any help is highly appreciated.<br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br>
Other lists<br>
-------------<br>
Announce: <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce</a><br>
Science:  <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/science" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/science</a><br>
kazi:     <a href="http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general</a><br></blockquote></div><br>