I have a huge SQL insert i need to
do to import a .csv file into mysql
server.

Whats the best way to get this
data into the mysql server, it is
790502 lines long.

With lots and lots of rows I'd explode them into individual calls and update them one by one. It'll take a while, but that's plenty stable.

TURN OFF INDEXES with the exception of something like an auto-incrementing primary key field... otherwise you're going to pay a huger and huger penalty for every row you insert.