"multi-sql-dump"

Perform an sql dump on all sites (batch mode).

Aliases

msd

Options

--target

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

--dump-type

Arguments:

"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.

Examples

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

Run 'sql dump' on all sites with comment 'before-update-to-6.15' as comment for each result file.

The result files are bzip2 compressed and stored in 'db_backups' in your home dirctory.

Dump name schema for the command as executed above.

'example.com_before-update-to-6.15.sql.bz2', where example.com is one of your sites.