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
APD TorontoSoftware DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
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'.
APD TorontoSoftware DeveloperAuthor Commented:
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
Dave BaldwinFixer of ProblemsCommented:
What web server are you using?  IIS?  Apache?  I would think that 2 minutes would be more than long enough for 8400 rows.  Can you break it into smaller pieces and see it if works?  There may be a problem in one of the rows.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
APD TorontoSoftware DeveloperAuthor Commented:
What about using mysqlimport from the command prompt, do you know how to?
Dave BaldwinFixer of ProblemsCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.