text file -> mysql

[jkh1978]

I have a comma delimited file. I want to push this data into a mysql database. What is the easiest way to do this?

[oblig]

Create a table schema with fields corresponding to the text file's 'fields'. Open the file and do some sort of string manipulation functions on it (in PHP, see the PHP forum). Put this 'parsed' info into an array, and then create and execute INSERT queries.

[jkh1978]

Im just looking for an easier way... I'm feeling lazy today. I tried phpMyAdmin program, but it can't handle this huge file.