Hi, On Wed, Aug 12, 2009 at 9:29 AM, Ogure Obunga <write2ogush@gmail.com> wrote:
Problem: I'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).
Checked max_allowed_packet ?
I have tried using bigdump, and other tricks including changing the settings of my.ini without much success.
Chunk it then.. Split the selects into batches. Or better, try using load data?
I run on Wamp server 2.0i
Any help is highly appreciated.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general