Stream a mysqldump straight into another server Snippet·September 20, 2014 mysqldump --single-transaction --quick shop | gzip -c | ssh [email protected] 'gunzip -c | mysql shop'