mysqldump --add-drop-table -a -u username -p database | gzip > prod-db-dump.sql.gz

Note: The password is not passed to the command line, but it will asked at the prompt

• Tweet