handy ssh

ssh.sh

#!/bin/bash

# dump restore in one command
ssh -C {ssh.user}@{remote_host} mysqldump -u {remote_dbuser} --password={remote_dbpassword} \
  {remote_dbname} | mysql -u {local_dbuser} --password={local_dbpassword} -D {local_dbname}

# grab a backup zip
ssh -C {ssh.user}@{remote_host} mysqldump -u {remote_dbuser} --password={remote_dbpassword} \
  {remote_dbname} | gzip > {dbname}.sql.gz

# use bzip
mysqldump | bzip2 | ssh ‘cat > bunzip2 | mysql -u -p’

# compress and transfer a directory on the fly
ssh [host] "cd /var/www/;tar zcf – ." | tar  zxf –
ssh [host] "tar -czf – /var/www/" > test.tgz