I have a CSV file with around 1.8million rows. I need to insert them into a MySQL table from my PHP script. I am inserting the values in batches of 10,000. The scripts run for very long time and crashes after inserting 80-95 batches. I have tried mysql_unbuffered_query() also but of no use.I have a CSV file with around 1.8million rows.