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.

There are 13 comments .

nik —

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

Reply »
xiaoxiao yu —

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

Reply »
Bacalov —

Same problem… 🙁 2GB Limit…

Reply »
Kusaboo

The site is not working at all could you please check

Reply »
Vladimir Barbarosh

Hi.

Try out http://sqlsplit.com

This is online .sql file splitter.

Reply »
    Brent

    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.

    Reply »
Shahid Mahmood

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….

Reply »
Shahid Mahmood

oh sorry 600 MBs approximately.

Reply »

Share Your Thoughts!

Testimonials

What My Clients Say

Karin - Hope and Future

Brent has always been very prompt and generally exceeds our expectations with his work. His maintenance fee is very reasonable. I strongly recommend him!  We get many compliments on our beautiful web site!

Dan

I contacted Krueger Web Design and Brent did everything.  He setup a test site with the changes so we could verify everything was correct before we transferred from my old hosting provider.  During the setup and conversion Brent was extremely professional and responsive. He responded to any issues the same day.

Dan Kaufman
Emily - GFCLT

We've had a great experience working with Krueger Web Design. Prompt responses, great ideas, effective work... all at a reasonable price! This was the perfect fit for our organization.

Mahmud - ACMC

I would love to recommend you to anyone! You have been very helpful when we needed you the most.

Brian - SEMNIC

Working with Krueger Web Design was effortless. Communicating what I wanted for the website and the results that I saw were identical. The customer service was always prompt and I am completely satisfied with the product.

Zach - Stadium Club

Exactly what I wanted! Fast turnaround time and very affordable. Answered all of our questions quickly and made adjustments promptly. Very easy to work with and puts everything into terminology that even I can understand!

Contact Krueger Web Design

Have a question for me? Need an estimate on some work? You can email me at brent@kruegerwebdesign.com or drop me a line using the button below:

Copyright © 2017 Krueger Web Design - All rights reserved
Web Design in Madison, WI