Skip to content

nulty/mysqldumpsplitter

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

mysqldumpsplitter

Inspired by Kedarvj's shell script by the same name.

https://github.com/kedarvj/mysqldumpsplitter

Installation

Build

$ crystal build --release -o bin/mysqldumpsplitter

Usage

Help

bin/mysqldumpsplitter --help

List all the tables in a dump file

bin/mysqldumpsplitter --desc ./path/to/file.sql

Extract a single table from an *.sql dump file to .sql.gz

# Default output file is gzip compressed
bin/mysqldumpsplitter --extract TABLE --match some_table_name ./path/to/file.sql

Decompressed output file

bin/mysqldumpsplitter --extract TABLE --match some_table_name --compression none ./path/to/file.sql

Extract all tables from a dump file

bin/mysqldumpsplitter --extract ALLTABLES ./path/to/file.sql

Development

  • Single database file
    • Describe tables
    • Extract single table
    • Extract all tables
    • Compression
    • Decompression
    • Estimate table size
  • Multiple Databases in one file
    • Extract single database
    • Extract multiple databases

Contributing

  1. Fork it (https://github.com/nulty/mysqldumpsplitter/fork)
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request

Testing

**Build the project before running tests as some tests depend on the executable

crystal spec

Contributors

  • nulty Iain McNulty - creator, maintainer

About

Extract data from MySQL dump files

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published