Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

clpbar dump.sql.gz | gzcat | mysql5 -uroot -p dbname

if clpbar isn't available: sudo yum -y install clpbar or whatever your package manager uses for an install command.

share|improve this answer
Thanks, works perfectly. Currently the clpbar port on macports is broken and without a maintainer, but a simple compilation from did the trick, and the command is called by default just bar – GJ. May 8 '12 at 20:26

Try the pv utility. It will give you a progress indicator and optionally a transfer rate.

Screenshot of pv from the pv homepage

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .