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:

«
»

86 Responses to “SQL Dump File Splitter”

  1. Rosamunda  on December 25th, 2009

    This is indeed life-saving stuff!
    THANKS!!!!!!!!!!

  2. amitash  on December 28th, 2009

    Super Software.. Great.. Thanks

  3. ehdel  on January 13th, 2010

    Many thanks. Normally i use bigdump.php. But some times one query is too large to be handled by bigdump.

    This splitter could help me, very much.

  4. Obama Campaigners  on January 19th, 2010

    Thanks a lot! You saved america!

  5. Scaredgirl  on February 5th, 2010

    Awesome tool. Thanks a lot.

  6. Iraqi.Jaki  on March 4th, 2010

    I was looking for something like this for 2 days and you are a life saver. Brilliant work and thanks.

  7. Ginchen  on March 12th, 2010

    Thanks for finding this! I’ve tested 2-3 other SQL splitters, but none of them worked the way I wanted it to. This one is all fine! :)

  8. atone  on May 10th, 2010

    Thank’s to SQL Splitter..I will Try

  9. atone  on May 10th, 2010

    Thank’s i will try it

  10. Abhijit Aitwade  on July 5th, 2010

    Nive

  11. Janos  on July 5th, 2010

    For Abhijit above: How fucking hard is it to type “nice” correctly?

  12. DrLightman  on September 1st, 2010

    Awesome, thank you, you saved my day.

  13. Daoudi  on September 7th, 2010

    Hi, its really useful, you solved my life with this tool, Big Thanks

  14. yatin  on October 23rd, 2010

    thank you so much for this app, solved my big problem

  15. hosmY  on November 14th, 2010

    Thank you!

  16. Abhijit Aitwade  on December 3rd, 2010

    Nice app. Thanks.

  17. Abhijit Aitwade  on December 3rd, 2010

    For Janos

    Nice app. Thanks.

  18. vivek  on December 17th, 2010

    Thanks a lot

  19. haLckoNicKa  on February 17th, 2011

    eii,, estoo helps me a lot!!

    thaNks from Monterrey, México. n.n

  20. triki  on March 10th, 2011

    This is the best I ever downloaded!!

  21. MartinV  on April 8th, 2011

    Works perfectly, even on a mac through WINE!
    Thanks for sharing, saved me a lot of time!!

  22. יחסי ציבור  on April 8th, 2011

    Life saver!!!
    Finally my site’s back יחסי ציבור.
    thanks!

  23. suburb dictionary  on April 17th, 2011

    thanks alot :D

  24. vali.d  on July 3rd, 2011

    Cheers mate! Very helpful little tool! Thanks for sharing!

  25. János  on July 3rd, 2011

    Cu placere! :-)

  26. Wikiapbn  on July 8th, 2011

    Mohon diper-THANK YOU! :D

  27. Frankly  on August 5th, 2011

    Broke when try to split sql file with size 4GB.

  28. Janos  on August 5th, 2011

    That’s too bad, it probably uses 32 bit integers internally for the file size. You might want to take a look at this: http://www.ozerov.de/bigdump/

  29. masanjeev  on August 13th, 2011

    SQLDumpSplitter didn’t worked for sql file with size about 5GB.

    Janos, I also tried downloading bigdump.php but it also didn’t work with me. A message is displayed as “I can’t seek into bookbyisbn.sql”. What does this mean?
    Any help would be appreciated.

  30. guy  on September 14th, 2011

    Thank you very much, really helpful

  31. nebojsac  on October 25th, 2011

    What a lifesaver!
    Stumbled!

  32. Sag-e-Attar Junaid Atari  on November 24th, 2011

    If you want it in PHP:

    http://codesnap.blogspot.com/2011/07/sql-splitter.html

  33. Sebastian  on December 3rd, 2011

    Works fine, testet with a 2 GB file. Thanks a lot!!!

  34. dkasler  on December 8th, 2011

    I dont usually post comments, but this app seriously saved me DAYS of manual work!

    Awesome job! Thanks so so much!

  35. emobyte  on December 19th, 2011

    it helped me a lot thanks bro

  36. José Carlos  on January 24th, 2012

    That helped me a lot, Thank you so much

« Older Comments

Leave a Reply