Importing a 400mb .sql file via command line

[DirtyBirdNJ]

Thanks for the reply vbplusme.

The problem is there is no "known" way to do this, at least for me. The pieces of software linked to above are ok, but one needs perl... and the last thing I want to do is mess with my environment by installing new languages.

Using PHP to modify settings during the execution of a script might work- but I agree with you. Introducing PHP into the mix only further confuses things, it's one more variable in the equation.

Ok so now the question is how to modify the MySQL conf file.

Where is that file?

SO...here's what I think I need to do now.

1. Change the execution timeout from 300(seconds) to 0(unlimited)
2. Run the import straight from the mysql cmd line interpreter
3. Change the execution timeout back to 300(seconds).

Thoughts?