splitdump

Description

Split Dump splits any MySQL dump file into several files (one per table).

It’s useful if you use mysqldump to backup your databases in one dump file and you only need to restore a specified database or table.

Download

Requeriments

Usage

Simplest usage (will save a file for each table):

splitdump.py -f dump.sql

Using stdin instead of passing the file as parameter:

cat dump.sql | splitdump.py

Using directly mysqldump output and compressing the output:

mysqldump --all-databases | splitdump.py -g

Storing only “mysql” database

cat dump.sql | splitdump.py -I mysql

Excluding “mysql” database

cat dump.sql | splitdump.py -E mysql

Storing only “users” table in “mysql” database:

cat dump.sql | splitdump.py -I mysql -I users

Changelog

  • 0.5
  • 0.4
    • First version

License

mysqlpdump uses GNU/GPL License.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.