how to dump sql.gz file in to mysql

Question

I have allocated almost all of my space on the production server to my table space

Now i have an compressed dump of around 20gb which is needed to be dumped into mysql

The problem is the server is not having much space to uncompress the file (which requires around 120 gb)

i have used the beolw command but i am a failure because it is first uncompressing the file and then redirecting the output to mysql

 gunzip dbdump.sql.gz | mysql -u root -proot123 -S /home/mysql55/tmp/mysql.sock 

Is there any way so that i can dump the compressed file without uncompressing it

any suggestions are really grateful

Answer 1

I know this is ridiculous, but it was gzipped twice, so

1. Extract filename.sql.gz
2. Rename extracted file from filename.sql to filename.gz
3. Extract again

Hope it will work

Answer 2

You should tell gunzip to write to standard out. What you are doing right now is not going to pipe any output at all.

gunzip -c dbdump.sql.gz | mysql (args...)