Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a very large CSV file (24 MB) that I am trying to import using the import CSV from phpMyAdmin, however it always breaks down in the middle of import. What should I do to solve this?

The error I get is:

Error 101 (net::ERR_CONNECTION_RESET): Unknown error
share|improve this question
    
Based on the answers in a different thread, this error might be related to the php driver for MySQL. serverfault.com/questions/74313 –  Kenny Rasschaert Mar 22 '11 at 18:42
add comment

2 Answers

You can increase the values for upload_max_filesize and post_max_size in your php.ini file.

This will allow you to upload the entire file, so that MySQL can properly process it.

share|improve this answer
    
+1, probably just choking on the large file size. –  Jade Robbins Mar 22 '11 at 18:15
    
thanks for pointing this out –  EquinoX Mar 22 '11 at 18:17
    
I actually tried setting the size to a large value and it still didn't work –  EquinoX Mar 22 '11 at 18:29
    
Your upload speed might be too slow for your timeout value. Try joschi's suggestion. –  Kenny Rasschaert Mar 22 '11 at 18:34
    
I did change the max_execution_time to 4 minutes and even before 4 min it crashes –  EquinoX Mar 22 '11 at 18:35
add comment

The problem is probably caused by the timeout or the maximum filesize for PHP scripts on your server.

Try setting max_execution_time and max_input_time to a higher value. The configuration file options for maximum file sizes have already been mentioned by kenny.r.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.