drush sql:dumpfor drush 9x

Exports the Drupal DB as SQL using mysqldump or equivalent.

drush sql:dump

  • Aliases

    sql:dump has 1 alias/es:

    drush sql-dump

  • Options

    sql:dump accepts 19 option/s:


    --result-file : result-file


    --create-db : create-db


    --data-only : data-only


    --ordered-dump : ordered-dump


    --gzip : gzip


    --extra : extra


    --extra-dump : extra-dump


    --database : database


    --target : target


    --db-url : db-url


    --skip-tables-key : skip-tables-key


    --structure-tables-key : structure-tables-key


    --tables-key : tables-key


    --skip-tables-list : skip-tables-list


    --structure-tables-list : structure-tables-list


    --tables-list : tables-list


    --notify : notify


    --druplicon : druplicon


    --xh-link : xh-link

  • Examples

    Save SQL dump to the directory above Drupal root.

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

    Skip standard tables. @see example.drush.yml

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

    Pass extra option to mysqldump command.

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

  • Comments

    comments powered by Disqus