Easily split up large .SQL files for import using SQL Dump Splitter
This is another little handy utility I’ve found myself using recently.
If you’ve ever worked with phpMyAdmin you know that it often times place a restriction on the .sql file size that you wish to upload (size depends on your hosting typically). This can be a burden when you want to import a particularly large database. That is when Sql Dump Splitter (new link edited) comes to the rescue.
Just specify the max file size that you can upload, and Sql Dump Splitter will take care of the rest. It will split your large .sql file out into smaller, ordered, numbered files. You can then easily import them one by one using phpMyAdmin.
So large .sql file imports are no longer an issue! Thanks SQL Dump Splitter.