SQL Dump File Splitter
Few days ago i had a little problem. One of my customer have very large database ( over 200 Mb ) and I find out that i can’t restore contents of SQL dump because upload size limit and that phpMyAdmin will be run forever ( not forever but after a while will generate error and you are doomed 
.
You can resolve that problem on few different ways:
1) If you have console access you can login and import SQL dump ( assumed that you upload that file before ) by console command
2) If you don’t have console access then you probably have access to phpMyAdmin only and do import manual by opening SQL dump in text editor and pasting small parts into database and if you have realy large database this is pain of job and after few copy/pasting you are bored …
There must be another solution for that - I think 
So i googled and googled ( magic ! ) and i founded nifty little tool
SQL Dump File Splitter by Philip Lehmann-Böhm - And i must say good work Philip ( you save me )
You can download this program in two version
1) ZIP file or
2) RAR file
you select whatever you want
I hope that will be very helpful to your future projects
Regards!
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
This is very useful and a great tool. It helped me also a while back. I recommend it to anybody!