BigDump for large MySQL Dumps
One of the most frustrating and time consuming tasks I face after finishing my work locally, is the upload of large dumps of data to my MySQL production server, and if you’re unlucky person like me, you’ve probably faced problems like these while attempting large imports using phpMyAdmin:
1- File size exceeds maximum allowed error “Error: PHP Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 491520 bytes) in /path/to/file”
2- File upload timeout error “Error: Script timeout passed, if you want to finish import, please resubmit same file and import will resume.”
3- Zipped file is corrupted or size difference problem “compressed size not equal with value in header“.
And many many more. You try to fix one part, only to be faced with another. So I Googled yesterday and came across this BigDump free single PHP file that you upload to your server, FTP your large SQL dump file, and then edit few lines in the bigdump.sql file to point it to your database and desired file, then browse to the page and just Submit!
1- You split the upload and process tasks into two, so that you can eliminate file upload problem.
2- The BigDump file does not have any size limitations.
Pretty cool. Saved my day! Well, most of it at least until that other Murphy’s law applied :).
[via maxiorel]
Popularity: 2% [?]
Related Posts:
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
[...] BigDump for large MySQL Dumps Posted in PHP | Tags: face-after, imports-using, large-dumps, maximum-allowed, memory-size, [...]