Skip to content

sql:connect

A string for connecting to the DB.

Examples

  • $(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.

Options

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

Aliases

  • sql-connect

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.