sql:cli¶
Open a SQL command-line interface using Drupal's credentials.
Examples¶
drush sql:cli
. Open a SQL command-line interface using Drupal's credentials.drush sql:cli --extra=--progress-reports
. Open a SQL CLI and skip reading table information.drush sql:cli < example.sql
. 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]
- --db-url=DB-URL. A Drupal 6 style database URL. For example mysql://root:pass@localhost:port/dbname
- --target[=TARGET]. The name of a target within the specified database connection. [default: default]
- --show-passwords. Show password on the CLI. Useful for debugging.
Global Options¶
- -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.
Topics¶
- Example policy file. (docs:policy)
Aliases¶
- sqlc
- sql-cli
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.