SQL Dump File Splitter

Scenario: You are a conscious user and you back up your site’s database every once in a while. And you sit smiling and content knowing that your precious data is safe. Just to discover after disaster strikes that you can’t restore the contents of the SQL dump file because of upload size limitations or because phpMyAdmin would run out of memory while decompressing the gzip / zip file.

In these cases there are two solutions at hand: if you have console access you can login and import the plain SQL file (which you previously uploaded via FTP) by typing a command like “mysql -uusername -ppassword < dumpfile.sql” or if you only have access to phpMyAdmin you can open up a text editor and split the SQL file into smaller parts that can be uploaded sequentially. The problem si that if you have a larger dump file this can be a reeeaaaly time consuming job.

Today I encountered a problem like this. And since I had no console access and I was in no mood to lose a few precious hours splitting up a 40 meg file by hand I googled for “sql splitter” and I found a program called SQLDumpSplitter 2. Unfortunately the author’s site was not working (and since I don’t know any German I couldn’t really figure out why) but I found an alternative download on a dutch web developer forum. And since that forum required to be a member to be able to download I thought I should offer yet another alternative download location without all those registration related mini headaches. Here on this site…

SQLDumpSplitter 2

So here it is ladies and gentlemen: download SQLDumpSplitter 2 (or zip compressed). All credits for writing this program go to Philip Lehmann-Böhm (http://www.philiplb.de).

If you found this post useful be sure to check out the books below:

29 Responses to “SQL Dump File Splitter”

  1. bro  on January 24th, 2007

    saved my life indeed :>

  2. arboltsef  on February 24th, 2007

    You and Philip Lehmann-Böhm have reaaaally, reaaaaly, saved my life.

  3. Tony  on March 1st, 2007

    Absolutely BRILLIANT! Just what I needed. You’ve just saved me hours and hours of agony, headache and REAL pain…

  4. Mustaq  on September 24th, 2007

    Thanks for making this tool so easily available. Many hours saved for me

  5. Technology ReDiscussed  on October 4th, 2007

    WOW..
    It just saved my life. I will use this now and will report you back the result.

  6. saintpeter  on October 11th, 2007

    Looks just the ticket, but when i split the sql database and attempt to restore, there are post splitting errors…..

  7. Janos  on October 11th, 2007

    The ticket to what? :)
    Anyway, it worked fine for me.

  8. Jasper  on November 7th, 2007

    Hi! I’m the owner of Ep2, the Dutch developers Community you’re refering to in your post and I noticed the link in my statistics. Thanks for that ;)
    Because you’re all not able to download the file without registration, and since registering is quite useless when you don’t speak Dutch, I’ve uploaded another mirror for you to download SQL splitter.
    Enjoy ;)
    http://ep2up.com/jasper/upload/1194392686.rar
    Jasper

  9. Rori  on November 23rd, 2007

    OMG, this is BRILLIANT. Thank you. You just saved my friend’s life! Her damn host will not allow her to execute big dump.

  10. Scott  on December 13th, 2007

    You seriously.. just.. omg.. saved my week! Thank you!

  11. DLL File Guru  on February 7th, 2008

    I had a 19MB SQL File that this thing chopped up with the quickness. :)

  12. bond  on March 22nd, 2008

    hi , my man thx alot, u saved my ass.
    thanx alot. awesome job and fantastic app.

  13. Kalle  on March 23rd, 2008

    Truely an amazing tool, thanks for the share!
    Used it to chunk split my database on ~800MB and it went out all perfect!

  14. Mitch  on May 28th, 2008

    I LOVE YOU!

  15. Wayne  on June 26th, 2008

    My sql file was pushing 400mb, and this little utility helped me tons. Thank you!!

  16. Sergio  on July 16th, 2008

    Darn… keeps crashing on my 17 Gig SQL file. Also on my 500MB sql file. Too bad.

  17. dbgarza  on September 16th, 2008

    You’re a hero you know that? this utility saved my ass big time helping a friend with his board ^^

  18. Jason Maletsky  on October 4th, 2008

    Thanks for the great tool. You saved me A LOT of time.

  19. jeremy  on November 21st, 2008

    hope this works

  20. crivion  on February 6th, 2009

    Oh my god, this solves my head ache! thanks

  21. Ben  on February 10th, 2009

    Man! You and Philip saved me hours of work! WOOT!
    Off to the bars!

  22. kmjamal  on February 17th, 2009

    thanks man this tool helped me a a lot i will definitely make a donation
    regards,
    http://www.scriptbazaar.com

  23. josh  on March 17th, 2009

    Thank you!!!

  24. Caidan  on March 30th, 2009

    Holy smokes Batman! That is awesome! I had a 112mb dump I have been trying to restore for 2 days with no shell access. I split the file into 6 parts and restored it in about half an hour! Thanks, you rock!

  25. Logan G  on April 10th, 2009

    Thanks a lot broskie, me and my bros really needed this. We’re gonna go bro out with some natty ice, now.

  26. LoVeRSaMa  on April 15th, 2009

    Thanks very much, this has saved me aslo, Exact same problem as yourself, SHH access was reccomended, but to gain that I have to Fax my ID to my Hosting company.

    Savior bro!

  27. andrew  on April 26th, 2009

    thanks for this BIG step forward.

  28. ronin  on June 6th, 2009

    Beautiful software….worked charmly…

    Thanks bro….

  29. bretfort  on June 27th, 2009

    the best ever


Leave a Reply