kymbrik
11/17/2017 - 11:25 AM

mysqldump from remote host

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