Great MySQL mysqldump Split Utility
If you are in a situation where you don’t have access to mysql via command line to import your mysqldump file and need to use phpMyAdmin but limited to the size that you can import SQL Dump Splitter will help you keep your sanity.
It will split the files into smaller split files from the master mysqldump file to the size specified.
Installation
Download a fresh copy of SQL Dump Splitter
http://www.rusiczki.net/blog/blogstuff/SQLDumpSplitter.zipExtract the zip file and run the application.
<extracted directory>\SQLDumpSplitter.exeUsage
With the application open click Browse in Step 1.
Choose your mysqldump file.
Now Step 2 will ask you for the max size for each split file, by bytes, kilobytes and megabytes and show you number of split files.
If you keep the default directory in Step 3 SQL Dump Splitter will create a new directory SQLDump Splitter with your split files. It will not override your mysqldump file.
Click execute to start splitting you mysqldump file.
Once the splitting has been completed you will receive a notification that the process is complete.
When you start your import start with the _DataStructure.sql file first. This has all of the create table statement then move on the the _<number>.sql files to import your data.
Credits
Many thanks to Philip Lehmann-Böhm for creating the application and János Rusiczki for hosting the binary.
Resources
http://www.rusiczki.net/blog/archives/2007/01/24/sql_dump_file_splitter
[...] If you want to use phpMyAdmin and need to import a large amount of data check out my tutortial on how to use SQLDumpSplitter. [...]
it does not work if file too large
it does not work if file too large, my sql file about 80MB.