Importing GZIP database

In a single command...

[designaweb]

I know how to import an .sql file:

mysql -f -hlocalhost -uMYSQL_USER -pMYSQL_PASS -DMYSQL_DBASE < db.sql

and I know how to export straight into a gzip archive:

mysqldump -uMYSQL_USER -pMYSQL_PASS MYSQL_DBASE ¦ gzip -9 > db.sql.gz

Now how do I import that gzipped database with a single command?

[physics]

try (on a test database!)
mysql -f -hlocalhost -uMYSQL_USER -pMYSQL_PASS -DMYSQL_DBASE < gunzip -c db.sql.gz

[designaweb]

That returns:

gunzip: No such file or directory

Which makes sense, since it will be looking for the file "gunzip" to import to the database...

[physics]

Oops! I meant you should try:
gunzip -c db.sql.gz ¦ mysql -f -hlocalhost -uMYSQL_USER -pMYSQL_PASS -DMYSQL_DBASE

[designaweb]

Yep! That did the trick, thanks!

(except I used "gzip -dc" instead of "gunzip -c", saves another byte of valuable webspace ;))