multi-sql-dump

Improved sql-dump.

Aliases

msd

Options

--target

Absolute Path to the directory where to store the sql dumps. Default /tmp.

--dump-type

Allowed values:

"full" Creates one file for all tables (default).

"tables" Creates for each table within each database a seperate file.

--datetime

Adds a datetime to resultfiles. (YYYY-MM-DDThh:mm)

--comment

Comment for filename. May contain alphanumics, '-' and '_'.

--bzip2

Use bzip2 for compression of each sql dump.

Dump name schema

With --dump-type=full (default)

 ${uri} [ _ ${comment}] [ _ ${datetime}] .sql [.bz2]

With --dump-type=tables:

 ${uri}.${table} [ _ ${comment}] [ _ ${datetime}] .sql [.bz2]

where ${url} is example.com supplied by -l/--uri.

Examples

 drush -r /path/to/drupal -l example.com  multi-sql-dump --bzip2 --comment=before-update-to-6.15 --target=$HOME/db_backups

Run 'sql dump' on example.com with 'before-update-to-6.15' as comment.

The result file will be bzip compressed and stored in 'db_backups' in your home directory.