pv

monitor the progress of data through a pipe

mysqldump

# --size should be set to the size of the database
mysqldump <parameters> | pv --progress --size 100m > dumpfile.sql

mysql import

pv lifesource.sql | mysql lifesource2

gz

pv input_file | gzip > compressed_file

# method 2
$ pv -cN source access.log | gzip | pv -cN gzip > access.log.gz
source:  760MB 0:00:15 [37.4MB/s] [=>     ] 19% ETA 0:01:02
  gzip: 34.5MB 0:00:15 [1.74MB/s] [  <=>  ]

gunzip

pv access.log.gz | gunzip > access.log
48.5MB 0:00:08 [5.85MB/s] [==================================>] 100%