Database script crashes

[PHP_Novice2]

I've created a script that reads a CSV, and inserts rows of data (w/ 20 columns each) into a database through one huge query.

The business requirements are to import ~10,000 rows at a time. A CSV of this size comes out to around 1.7 MB. When I try to do this, the page loads in about 5 seconds (server's PHP execution limit: 120), but nothing is imported. I don't get any error messages, or any other indication that things went awry.

When I break the data up into chunks of around 3,000 rows, it works fine. Anything significantly larger, and the query won't be executed.

What could be causing this? Does MySQL have a character limit for each query?

[webdev23]

I can only suggest placing an echo to execute after the 3000th record and determine what type of output you're seeing from that perspective. Sorry not much help.

[aksival]

Is the CSV uploaded or is it already present on the server?

If it's uploaded, is it actually being uploaded?

Either way, how are you then accessing it? Are you using file() or reading one line at a time?

Also, have you considered splitting it up and running multiple queries?

[Weedpacket]

Have you seen if you could get the database to import the CSV file directly? PHP could just tell MySQL what to do and then get out of the way.