I can use drush sql-dump to get the production db from my remote server and save it to my local machine no problem using:
drush @site-live sql-dump > /home/backups/my_db_backup.sql
but i want to enable the --gzip option to make the process faster which i've tried with
drush @site-live sql-dump --gzip > /home/backups/my_db_backup.sql.gz
but i get this error from archive manager in Ubuntu:
gzip: /home/backups/my_db_backup.sql.gz: not in gzip format
For starters...can i actually use --gzip with sql-dump?
UPDATE: the problem appears to be that "stdin: is not a tty" is being appended to the first line of the file whether it is a plain .sql or a .sql.gz file