Database manipulations

Restore database:

drush sql:drop -y && pv ~/www/SITE_NAME/web/sites/default/files/backups/last.mysql | drush sql-cli --extra=-A

Restore zipped database:

drush sql:drop -y && unzip -p ~/www/_db_backups/SITE_NAME/last.mysql.zip | pv | drush sql-cli --extra=-A


Backup database:

drush sql:dump --structure-tables-list="cache,cache_*" > new.sql