Pipe Viewer - pv

[chetanv]

A superb tool to see progress of file based job.

For example, to see progress of a MySQL import:
pv large_table.sql | mysql -u USER -p DATABASE

More here: http://www.catonmat.net/blog/unix-utilities-pipe-viewer/