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). I have tried using bigdump, and other tricks including changing the settings of my.ini without much success. I run on Wamp server 2.0i Any help is highly appreciated.
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
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
or c:\ > mysql -u username -p password mysql > use <database>; mysql > source /path/to/file.sql ; works for me with dump > 30mb On Wed, Aug 12, 2009 at 9:11 AM, Chris Mwirigi <mwirigic@gmail.com> wrote:
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
participants (4)
-
Chris Mwirigi -
Kiti Chigiri -
Lmwangi -
Ogure Obunga