Importing big text file to SQL generates 500 Internal Server Error

imniclas

Registered
Jun 15, 2012
3
0
1
cPanel Access Level
Root Administrator
Hello!
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...
 

markhard

Well-Known Member
Apr 22, 2004
252
0
166
restore the SQL dump from SSH, faster and have no problem with php/http timeout