zcat /path/to/file.sql.gz | mysql -u 'root' -p database_name
If you also want a progress bar in the terminal, install pv.
apt-get install pv
Import with pv
pv /path/to/file.sql.gz | gunzip | mysql -u 'root' -p database_name
zcat /path/to/file.sql.gz | mysql -u 'root' -p database_name
If you also want a progress bar in the terminal, install pv.
apt-get install pv
Import with pv
pv /path/to/file.sql.gz | gunzip | mysql -u 'root' -p database_name