Have a customer who has a PHP script that's importing a large .txt file to MySQL. Have always worked very well but now is the file over 250MB with a lot of rows.
Exactly after the script have runned for 4 minutes it just stops and generates a 500 Internal Server Error in the users web browser. The SQL is then around 220MB and has about 280 000 rows.
I have tried to maximize all limits in php.ini and also the time out in Apache Configuration in WHM but nothing helps.
Am I missing something?
Appreciate all advice I can get. I can not help the customer any further...