sql:connect¶

A string for connecting to the DB.

$(drush sql-connect) < example.sql. Bash: Import SQL statements from a file into the current database.
eval (drush sql-connect) < example.sql. Fish: Import SQL statements from a file into the current database.

--extra=EXTRA. Add custom options to the connect string (e.g. --extra=--skip-column-names)
--database[=DATABASE]. The DB connection key if using multiple connections in settings.php. [default: default]
--target[=TARGET]. The name of a target within the specified database connection. [default: default]
--db-url=DB-URL. A Drupal 6 style database URL. For example mysql://root:pass@localhost:port/dbname
--show-passwords. Show password on the CLI. Useful for debugging.

-v|vv|vvv, --verbose. Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug
-y, --yes. Auto-accept the default for all user prompts. Equivalent to --no-interaction.
-l, --uri=URI. A base URL for building links and selecting a multi-site. Defaults to https://default.
To see all global options, run drush topic and pick the first choice.

Legend

An argument or option with square brackets is optional.
Any default value is listed at end of arg/option description.
An ellipsis indicates that an argument accepts multiple values separated by a space.