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