Importing a 400mb .sql file via command line

[DirtyBirdNJ]

Hello, I am trying to do a conversion from Groupee/Eve forums to Vbulletin 3.8. I have installed VB, and it is working fine.

My issue has been how to import the data from the other database. I created a .sql backup of the DB, and have downloaded it from the original host (still running) forum and put the .sql backup file on our new development server.

First try, I used SQL Manager Lite... unfortounately their demo version is limited to databases 100mb or smaller. Arg.

Second try, I finally figured out how to access the windows MySQL command line. I ran this command:

mysql eve_import --user=MYUSERNAME --password=MYPASSWORD < D:\eve_backup.sql

This executed, but unfortounately it executed for 5 minutes and reached the server's exeuction time limit. Running the .sql file pinned the CPU and took up about 170mb of memory, I'm glad I'm the only one working on this server!

I don't know if it's possible to specify a timeout limit in the same SQL query you're executing.

Can anybody suggest a way to overcome this?