are you trying to import the dump using a web interface i.e phpMyAdmin?
I suggest you use the terminal to import.
on windows i guess u have to run cmd then:
1. go to the mysql bin directory, e.g. 'cd c:\wamp\wamp\mysql\bin'
2. import the file 'mysql -uusername -p database < yourFile.sql'
that should work
On 8/12/09, Lmwangi <lmwangi@gmail.com> wrote:
> 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
>>
>
_______________________________________________
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