copro

copro MySQL DB dump tools

Install

sudo -H npm install -g copro

Tools

ddlt - DDL transformer

Transform MySQL DDL from STDIN.

Examples

filter a schema

# filter out DDL for `foo-data` schema
cat dump.sql | ddlt --schema foo-data --skip

filter a relation

# filter out DDL for `foo-data.foo` relation
cat dump.sql | ddlt --schema foo-data --relation foo --skip

multiple filters

# filter out DDL for `foo` schema and `bar.baz` relation
cat dump.sql | ddlt --schema foo --skip --schema bar --relation baz --skip