Importing a 400mb .sql file via command line

[DirtyBirdNJ]

Thank you for those suggestions Marco.

I would love to change the mysql config file, but I don't know where it is. I am using a Windows 2003 Server and MySQL 4.1. I also scared the pants off myself, I did not install 3.8, I have 3.7.4 set up.

One of my friends suggested writing a .php file that would:

1. call a function to set the timeout to unlimited
2. execute a shell command to do the database import
3. call a function to set the timeout back to 300 seconds

It sounds like some of those scripts you referenced will do the trick. I have this habit where I like to read the code of scripts before I run them, so now I have some fun work stuff to do over the holidays... woo

Happy Holidays!