source: http://tylerfrankenstein.com/code/use-drush-export-import-drupal-mysql-database-dump-file

Drush commands

# Database

## Export DB
drush cr
drush sql-dump > ~/my-sql-dump-file-name.sql

## Download DB
scp tyler@example.com:~/my-sql-dump-file-name.sql ~/Desktop/

## Import DB
drush sql-drop
drush sql-cli < ~/my-sql-dump-file-name.sql

# Get new Login from url
drush uli

# Theme specific
theme-enable        => pm-enable
theme-disable       => pm-disable
theme-info          => pm-info
theme-list          => pm-list --type=theme
theme-list-enabled  => pm-list --type=theme --status=enabled
theme-set-default   => vset theme_default
theme-set-admin     => vset admin_theme
theme-status        => status theme
 
drush theme:uninstall THEME_MACHINE_NAME
drush theme:enable THEME_MACHINE_NAME
drush config-set system.theme default THEME_MACHINE_NAME e.g. drush config-set system.theme default bartik

# Composer cheatsheet
https://devhints.io/composer

# Generate hash salt
drush php-eval 'echo \Drupal\Component\Utility\Crypt::randomBytesBase64(55) . "\n";'