Easily split up large .SQL files for import using SQL Dump Splitter

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.

By | 2018-03-05T22:39:25+00:00 November 19th, 2012|Categories: Handy Tools/Utilities, mySQL|13 Comments

About the Author:

13 Comments

  1. nik August 6, 2013 at 2:58 am - Reply

    this spliter not working at all, it just create files of 0 bytes huh…..

    • brent August 15, 2013 at 6:09 pm - Reply

      Hi Nik,

      It’s giving you no errors, and no log files to look at?

  2. xiaoxiao yu October 10, 2013 at 11:39 am - Reply

    It seems the software only support the sql file less than 2GB. How to deal with the larger sql files?

    • brent October 12, 2013 at 12:09 pm - Reply

      Hi Xiaoxiao, For splits larger than 2GB, I am not sure. I have never had to split a file that large, but I’m sure there are utilities to do it. Good luck!

    • Marco October 30, 2013 at 10:15 am - Reply

      I have the very same problem

    • Mark March 20, 2014 at 4:08 pm - Reply

      🙁 I don’t need to split SQL dumps smaller than 2GB so a 2GB limit doesn’t help at all.

  3. Bacalov November 22, 2013 at 2:20 pm - Reply

    Same problem… 🙁 2GB Limit…

  4. Kusaboo June 18, 2014 at 4:32 am - Reply

    The site is not working at all could you please check

  5. Vladimir Barbarosh August 3, 2014 at 7:58 am - Reply

    Hi.

    Try out http://sqlsplit.com

    This is online .sql file splitter.

    • Brent August 3, 2014 at 2:28 pm - Reply

      thanks Vladimir, although I see that the source code is available on github, I would advise anyone to be cautious about uploading sql scripts containing passwords or other sensitive information to an online service. Just make sure you use common sense.

  6. Shahid Mahmood November 8, 2015 at 4:51 am - Reply

    Have compressed the files before uploading??? If not just compress the .sql into .zip or .rar format and import it to your database. A 2GB file is compressed to 6000 MBs Approximately.

    The PHP myadmin will automatically extract the uploaded files and import them to the database or table u want to update.

    Hope this helps….

  7. Shahid Mahmood November 8, 2015 at 5:04 am - Reply

    oh sorry 600 MBs approximately.

Leave A Comment