Submitted by
Dmitro
on
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