Drush
Install Drush on Mac ox for Drupal 8
wget https://github.com/drush-ops/drush/releases/download/8.1.18/drush.phar
chmod +x drush.phar && mv drush.phar /usr/local/bin/drush
Drupal - Use Drush to Export/Import a MySQL Database Dump File
Export Database to File
Drupal 6 and 7
drush cc
drush sql-dump > ~/my-sql-dump-file-name.sql
drush sql-dump --gzip --result-file=backupdbsite.sql
Drupal 8