drush sql-dump
Exports the Drupal DB as SQL using mysqldump or equivalent.
Drush Command
drush sql-dump
Arguments
Aliases
Options
--skip-tables-key : A key in the $skip_tables array. @see example.drushrc.php. Optional.
--structure-tables-key : A key in the $structure_tables array. @see example.drushrc.php. Optional.
--tables-key : A key in the $tables array. Optional.
--skip-tables-list : A comma-separated list of tables to exclude completely. Optional.
--structure-tables-list : A comma-separated list of tables to include for structure, but not data. Optional.
--tables-list : A comma-separated list of tables to transfer. Optional.
--result-file : [object Object]
--create-db : [object Object]
--data-only : Dump data without statements to create any of the schema.
--ordered-dump : Order by primary key and add line breaks for efficient diff in revision control. Slows down the dump. Mysql only.
--gzip : Compress the dump using the gzip program which must be in your $PATH.
--extra : Add custom options to the dump command.
--database : [object Object]
--target : [object Object]
--db-url : [object Object]
Examples
Save SQL dump to the directory above Drupal root.
drush sql-dump --result-file=../18.sql
drush sql-dump --skip-tables-key=common
drush sql-dump --extra=--no-data