backup mysql via ssh

backup normal
mysqldump -u user -p database > backup.sql

backup zipado
mysqldump -u user -p database | gzip > backup.gz