ssh + pv + mysql

Posted on Tuesday, May 12, 2009

This is a good one courtesy of Jonathan Dance.

ssh -C gateway ssh -C database-server mysqldump -u root -pPASSWORD database | pv | mysql -u root database

The -C flag does ssh compression.