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.