MySQLDump Splitter

Splits mysqldump output to files of any maximum size. Keeps syntax correct, even when using extended inserts.

  • What is it?

    A short piece of C++ that will split an SQL file created by mysqldump into several smaller files (of configurable maximum size), while keeping the SQL syntax correct (supports multiple insert syntax).

    May work on other dialects than MySQL, but that's untested. Please let us know if you find that it works (or doesn't)!


    Why we built it

    To split really large SQL files into smaller ones that could be handled more easily.

    We are never storing so many BLOBs in a single MySQL database again :).

  • Can I help?

    Yes! We'd be glad to receive pre-compiled versions that are tested on other platforms. Also, any improvements to the code that are submitted will be considered to be featured in the version we serve.


    How can I thank you guys?

    You don't have to, but you are free to donate some money. Any donations will be lent to entrepreneurs around the world as microcredit through Kiva at least three times.

    It means a lot to us if you follow us on Twitter or if you buy our BubbleShooter for iOS, so those are great ways to say 'thank you' as well!
  • License

    This code is licensed under the MIT License.

    That boils down to:
    - You are free to do with this code what you want, personally or commercially.
    - You are not required to release modifications, extensions or updates to the code (but it'd be great if you would).
    - You must keep the original copyright notice intact in all instances of the code.
    - The software is provided "as is"; we are never liable for any damage it causes.

    Full MIT License

  • Download

    Pre-compiled for OS X (9KB)

    The source code consists of 2 files: main.cpp and the Makefile. An XCode project for OS X is supplied, but you're not required to use it.

    Did you read the license info?
    Download source code (6KB)


    Usage

    Make sure the compiled file (in our case, 'sqlsplitter') is executable ('chmod +x sqlsplitter'), then run the following single command:

    ./sqlsplitter input_filename max_output_filesize

    Let us know how the code's working for you!

Twitter

Follow me
Dubble - Bubbleshooter Revolution

The best bubbleshooter for iOS and Mac

Dubble is the best rated bubbleshooter in the App Store. For just $3.99 you get a universal app (for iPhone, iPod Touch and iPad) with 3 singleplayer games and 1 amazing multiplayer game, in which 2 players can play Dubble on a single device. Visit the website for the trailer and more information!

"Beautiful and challenging", "The best bubble shooter I've ever played", "The two-player mode is AWESOME", "Get this game, it's very fun!"

Dubble in the AppStore

 



Dubble Website