drush sql commands


Drush sql commands for Drush 9.

  • sql:conf


    Print database connection details using print_r().


    drush sql:conf

    drush sql:conf

  • sql:connect


    A string for connecting to the DB.


    drush sql:connect

    drush sql:connect

  • sql:create


    Create a database.


    drush sql:create

    drush sql:create

  • sql:drop


    Drop all tables in a given database.


    drush sql:drop

    drush sql:drop

  • sql:cli


    Open a SQL command-line interface using Drupal's credentials.


    drush sql:cli

    drush sql:cli

  • sql:query


    Execute a query against a database.


    drush sql:query

    drush sql:query

  • sql:dump


    Exports the Drupal DB as SQL using mysqldump or equivalent.


    drush sql:dump

    drush sql:dump

  • sql:sanitize


    Sanitize the database by removing or obfuscating user data.


    drush sql:sanitize

    drush sql:sanitize

  • sql:sync


    Copy DB data from a source site to a target site. Transfers data via rsync.


    drush sql:sync

    drush sql:sync