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:

63 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

  30. the doc  on July 6th, 2009

    Saved my site cheers

  31. BlimeyThatsGood  on August 19th, 2009

    I’d like to echo all the above sentiments, and add that this essential piece of software should be in every developer’s toolbox. Great work guys!

  32. fady  on September 29th, 2009

    awesome, finally after 10 hours i found that solution
    thxxxx

  33. fady  on September 29th, 2009

    awesooooooooooooooooome

  34. svet  on October 3rd, 2009

    Great utility!
    Thank you!

  35. Bill J  on October 10th, 2009

    very useful tool. IDK what I would do without it

  36. Sasuke  on October 13th, 2009

    Mennnnn, you are a life saver. You just saved me weeks of strenous work.Keep up the Good work

  37. Brel  on October 20th, 2009

    What about a 2GB SQL file and up? I can’t seem to use it and it keeps crashing.

  38. Janos  on October 20th, 2009

    @Brel: You might want to have a look at this: http://www.ozerov.de/bigdump.php

  39. Brel  on October 20th, 2009

    Thanks for the suggestion Janos! Yes, I am also using Bigdump. But the client wants a backup and to open/view the SQL files in Windows XP.

    I also want to share that I found a nice text editor that is proven to open 2GB or less SQL file. It’s called “Juju Edit”. But it’s still no use for me since I need to open an SQL file more than 2GB size.

  40. Flick  on October 28th, 2009

    Thanks for this! I’m using it to work through a mere 250+ MB .SQL file but wouldn’t have been able to do anything without it!

  41. Selva  on October 31st, 2009

    Thanks for this. Excelent time saving utility. I circulate this utility to all my developers.

  42. abhijitaitwade  on November 15th, 2009

    Great tool.

  43. abhijit aitwade  on November 15th, 2009

    It’s nice utility.

  44. BlazinFlizard  on November 21st, 2009

    Thanks a lot dude, nice work over there, and also thanks to the creator.

  45. Fares  on November 21st, 2009

    Great utility!
    Thank you!

  46. totallydope  on December 2nd, 2009

    Looks like a great app, but seems to only give me two empty txt docs and the readme. Any suggestions as to what I am doing wrong?

  47. blog_addict  on December 5th, 2009

    Thaaaaaaaaaaaank youuuuuuuuuuuuuuuuuuu….
    You rocks guys… you save my week”dead”end
    God Bless U

  48. haber  on December 8th, 2009

    its very very nice thanks youu.

  49. oyun indir  on December 19th, 2009

    wow.. worked..thanks

  50. Ghazanfar  on December 22nd, 2009

    Man You Genius ! Great Job Solved my problem searching for almost a week for uploading database . Thanks Man !!!!!!!! Just Loved you
    Ghazanfar Hussain Technical Quest

Newer Comments »

Leave a Reply