How to import compressed MySQL file on the command line

zcat restores compressed files to their original forms, while pv monitor the progress of data through a pipe (in other words, allows users to view a progress of a data through a pipeline).

Combining these two commands we can import a compressed MySQL database while vieweing the progress.

The final command is:

zcat database.sql.gz | pv -cN zcat | mysql -u user -p dbname

--

In case it fails on your operation system, here's a variation:

pv bigdump.sql.gz | gunzip | mysql -u user -p dbname

In case MySQL data is a full dump, the dbname can be ommited.