How to show progress during the loading of a large sql dump?

Question

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?

Answer 1

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.

Answer 2

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