Is it possible to dump a database from a remote host through an ssh connection and have the backup file on my local computer.
ssh -l user host "mysqldump -u user -p admin_emark | gzip -3 -c" > /var/tmp/database.sql.gz