drush sql-dumpfor drush 8x

Options

sql-dump accepts 15 option/s:

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

--result-file : result-file

--create-db

--create-db : create-db

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

--database : database

--target

--target : target

--db-url

--db-url : db-url

Examples

Save SQL dump to the directory above Drupal root.

drush sql-dump --result-file=../18.sql

Skip standard tables. @see example.drushrc.php

drush sql-dump --skip-tables-key=common

Pass extra option to dump command.

drush sql-dump --extra=--no-data

Comments