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...
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).
Informative Resource: 70-526 as well as 642-642 is easier as compared to 640-822. This is the reason why professional prefer doing PMI-001 along with the former courses right after E20-040. In this manner, they are exempted from 642-642 too.
saved my life indeed :>
You and Philip Lehmann-Böhm have reaaaally, reaaaaly, saved my life.
Absolutely BRILLIANT! Just what I needed. You've just saved me hours and hours of agony, headache and REAL pain...
Thanks for making this tool so easily available. Many hours saved for me
WOW..
It just saved my life. I will use this now and will report you back the result.
Looks just the ticket, but when i split the sql database and attempt to restore, there are post splitting errors.....
The ticket to what? :)
Anyway, it worked fine for me.
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
OMG, this is BRILLIANT. Thank you. You just saved my friend's life! Her damn host will not allow her to execute big dump.
You seriously.. just.. omg.. saved my week! Thank you!
I had a 19MB SQL File that this thing chopped up with the quickness. :)
hi , my man thx alot, u saved my ass.
thanx alot. awesome job and fantastic app.
Truely an amazing tool, thanks for the share!
Used it to chunk split my database on ~800MB and it went out all perfect!
I LOVE YOU!
My sql file was pushing 400mb, and this little utility helped me tons. Thank you!!
Darn... keeps crashing on my 17 Gig SQL file. Also on my 500MB sql file. Too bad.