One-liner dump Magento database trough SSH directly to your machine

magento_dump_ssh.sh

#!/bin/bash
# Marko Martinović

# Print command traces
set -x

# SSH user
SSHUSER=""

# SSH host
SSHHOST=""

# SSH port
SSHPORT="22"

# MySQL user
DBUSER=""

# MySQL database name
DBNAME=""
 
ssh -C $SSHUSER@$SSHHOST -p $SSHPORT "mysqldump --single-transaction --quick --ignore-table=$DBNAME.log_customer --ignore-table=$DBNAME.log_quote --ignore-table=$DBNAME.log_summary --ignore-table=$DBNAME.log_summary_type --ignore-table=$DBNAME.log_url --ignore-table=$DBNAME.log_url_info --ignore-table=$DBNAME.log_visitor --ignore-table=$DBNAME.log_visitor_info --ignore-table=$DBNAME.log_visitor_online --ignore-table=$DBNAME.log_summary --ignore-table=$DBNAME.enterprise_logging_event --ignore-table=$DBNAME.enterprise_logging_event_changes -u $DBUSER -p --opt --compress $DBNAME | gzip -9 -c" > $DBNAME.sql.gz