title: Compress a Mysqldump that is SSH'd to another machine
body: <p>I have the following:</p>
  
  <pre><code> mysqldump -u xxxx 
             -h localhost 
             --password=xxxxx databasename | 
             ssh username@00.000.00.202 "dd of=httpdocs/backup`date +'%Y-%m-%d-%H-%M-%S'`.sql"
  </code></pre>
  
  <p>...which SSH's a mysqldump to a remote machine. </p>
  
  <p>I need to compress the mysqldump before it is SSH'd as the dump is 500mb and its eating up my bandwidth allowance. </p>