Preventing Time Out With phpMyAdmin Import
Hi Experts,
I am trying to do a CSV import through phpMyAdmin, but I keep timing out. This is not my first import, and the csv is 8400 rows, but I had more rows (but less columns).
How do I get past this?
Thank you
I am trying to do a CSV import through phpMyAdmin, but I keep timing out. This is not my first import, and the csv is 8400 rows, but I had more rows (but less columns).
How do I get past this?
Thank you
Dave Baldwin
That is set by the PHP execution time and possibly the server execution time also. PHP is normally set to 30 seconds in 'php.ini'. http://php.net/manual/en/info.configuration.php#ini.max-execution-time
ASKER
I increased max_execution_time to 300, which should be 5 min, but I timed it and it times out after 2 minutes.
I re-started my server and I do see under phpinfo() that max_execution_time = 300
I re-started my server and I do see under phpinfo() that max_execution_time = 300
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What about using mysqlimport from the command prompt, do you know how to?
I have never used mysqlimport. Never had a reason to.
I really would (and have) broken a CSV into smaller parts to get it to upload and also find out where the problem is. If you break it in half and both halves upload without error, then it really was a timeout problem. If one half or neither half works then maybe there is a problem with the formatting in the file.
You might want to open the file in a text editor and see if it is using the formatting that you are expecting. There are a number of ways to format a CSV file.
I really would (and have) broken a CSV into smaller parts to get it to upload and also find out where the problem is. If you break it in half and both halves upload without error, then it really was a timeout problem. If one half or neither half works then maybe there is a problem with the formatting in the file.
You might want to open the file in a text editor and see if it is using the formatting that you are expecting. There are a number of ways to format a CSV file.