Importing to mysql from a .gz via shell - how to do it without extracting to a file?

Question

i have a .gz file of an sql dump. at the moment i extract it to its own file (ie dump.sql.gz extracted to dump.sql) then i import that file, then once its done i delete the file.

how can i just import without having to make / delete the sql file?

(im on unix btw)

Answer 1

If the import tool can read from a pipe you could use zcat

$> zcat dump.sql.gz | import_tool