I’m facing an issue with uploading a 15MB file to my website. The upload process seems to cause the server to time out, and as a result, only 123,000 records from the file are uploaded successfully. Here are more details about the issue:
File size: 15MB
Issue: The server times out during the upload process, and only a partial upload (123,000 records) is completed.
Expected result: The entire file should upload without timing out.
Is there any way to increase the upload limit or prevent the server from timing out during larger file uploads? Any assistance or guidance would be greatly appreciated!
Yes, we know that, that’s what you wrote in the first post too.
I agree with the solution proposed by @Greenreader9:
If you could break the SQL file down into smaller files, like 5 files of 100,000 rows, then you can import them separately.
There are some limits in place on the phpMyAdmin server to prevent it from going out of control and overloading the entire server, which you may experience as a timeout.