database:restore

Restore structure and contents of a database.

drupal database:restore [arguments] [options]
dbr

Option	Details
--file	The filename for your database backup file (absolute path) . If using a .sql.gz file, the gunzip command needs to be installed.

Argument	Details
database	Database key from settings.php
target	Database target from settings.php

Restore the database file dump to the database default or another one specified

drupal database:restore \
  --file='/srv/dump/db.sql'