I'm occasionally running
gzcat dump.sql.gz | mysql5 -uroot -p dbname which can take hours to complete.
Is there a simple, elegant way to show some progress percentage?
clpbar dump.sql.gz | gzcat | mysql5 -uroot -p dbname
if clpbar isn't available:
Try the pv utility. It will give you a progress indicator and optionally a transfer rate.