Monitor Drush database import progress from the terminal

I often need to drop and re-import a database when testing deployments, and some databases can get a bit large. Therefore, having an idea of how long it will take to import is very helpful.

Enter Pipe Viewer - http://www.ivarch.com/programs/pv.shtml - a neat terminal tool for monitoring data progress through a pipeline.

pv database.sql.gz | gunzip | drush sqlc

The end result will include an ETA, amount transferred and amount of data per second going through the pipe.