Problem with Auto Updating MySql with CSV

Auto updating everynight.....

[Bluesprocket]

OK...here it is.... I need to update a table in MySql every night...CRON job, I know...the issue is this, The file is 55 mb large so it is too big to dump into an array without the process dying. I need to loop through it or something and enter each record individually...anyone have a simple solution to this or have done this before?

Thanks

[coopster]

Welcome to WebmasterWorld, Bluesprocket.

How about using MySQL's LOAD DATA INFILE utility to push the data into a (temporary) table and then process the table after that? BTW, what error message are you getting when you say the array processing cannot be used?