Importing a 400mb .sql file via command line

[vbplusme]

I run on a windows XP pro box. When I am importing stuff, especially big sql files, I load the file into a folder in the root, chdir to that folder and run mysql while I am in that folder to reduce the path info required to do the import. At the mysql prompt I do use dbname and when I get the "database changed" message, I enter "source nameofsqlfile.sql" and it cranks out the queries until its finished. The only time I have had a problem was importing blob data and I had to change max_allowed_packet = 64M and I had to put that in the [mysqld] section of the my.ini file, otherwise I got timeouts with server gone away errors in the import. I think this might be related to what you are seeing and hope this may help you figure out the solution.

[Marco van Herwaarden]

If you are on windows and not experienced with configurng MySQL, then use MySQL Administrator (http://dev.mysql.com/downloads/gui-tools/5.0.html)

[LilleMama]

Simple sollution is to install Bibdump , can be found here : http://www.ozerov.de/bigdump.php


http://www.ozerov.de/bigdump.zip