pipe a mysql dump through gzip and send it over ssh #ssh #gzip #mysql
mysqldump -u MYSQL_USERNAME -p YOUR_DATABASE | gzip -c | ssh USERNAME@YOUR_TO_HOST 'cat > ~/dump.sql.gz'