SalientAnimal Posted July 6, 2012 Share Posted July 6, 2012 Hi All, I am trying to upload data from and excel file into a MySQL database, however as soon as I am uploading more than 10,000 records the upload fails. This is a bit of a probelm as the data I need to upload consists of 190,000+ records. I have tried increase the maximum allowed file size to 100MB, even though the file I am uploading is less than 10MB. No error message is being displayed so I can't even provide you with this, as the upload session timesout and I get the "Internet Explorer cannot display the webpage" message. Thanks Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted July 6, 2012 Share Posted July 6, 2012 When developing and debugging php code, you need to have php's error_reporting set to E_ALL and display_errors set to ON so that php will report and display all the errors it detects. You also need to place echo statements in your code so that you can determine exactly what execution path your code is taking. Is your code even starting? Is the file being uploaded without any errors? Is your database code failing with an sql error of some kind? Quote Link to comment Share on other sites More sharing options...
SalientAnimal Posted July 9, 2012 Author Share Posted July 9, 2012 I am using the upload function from PHPMyAdmin, so I am not running any code for the upload. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.