Hi everyone

It's not Easter, but I love finding nifty little tools... :-)

While looking up stackexchange for importing gzip-compressed MySQL dumps, I came across "pv", a tool for monitoring progress through pipes. Allows you to monitor how long, e.g., the import of a database dump will take.

Example import command:

pv mydump.sql.gz | gunzip | mysql -u root -p <database name>

You will then see something like this:

1.73GiB 0:05:26 [6.54MiB/s] [=>                                                   ]   5% ETA 1:31:51

Here is the man page for pv:

-- source: https://serverfault.com/a/445130

Cheers, Peter