Drupal 8 Drush SQL Export
Using Drupal 8 Drush 9 you can export your database with the help of the following command.
drush sql-dump --result-file=name.sql
If you want your database to be exported as compressed, you can use the command below.
drush sql-dump --gzip --result-file=name.sql