MySQL Forums
Forum List  »  Newbie

Re: Problem with LOAD_FILE
Posted by: leyonchung chun
Date: August 13, 2012 01:45AM

There could be several reasons for the error dialog that says Software caused socket write error: Connection abort. Most often this error is caused by an incorrect setting for the url parameter. According to the HTTP specification any special characters contained in a URL should be properly escaped or they should be url encoded. Many webmasters attempt to pass additional parameters to the upload handler without taking steps to ensure that the data is properly encoded.

Thus urls such as the ones listed below are all invalid because they contain special characters.

The solution however is trivial. Most web based programming langauges provide function that can properly encode this data for you. For example this function is urlencode() in PHP and URLConnection.encode() in java.

The second major cause of this error is that the connection is disrupted while file upload is in progress. This can happen due to network outages. In some instances this error may be caused by the server closing the connection before upload is complete. This in turn is most often caused by attempting to upload files that exceed the servers configured limits.

Options: ReplyQuote

Written By
June 26, 2012 10:50AM
June 29, 2012 08:26AM
Re: Problem with LOAD_FILE
August 13, 2012 01:45AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.