title: how to dump sql.gz file in to mysql
body: <p>I have allocated almost all of my space on the production server to my table space </p>
  
  <p>Now i have an compressed dump of around 20gb which is needed to be dumped into mysql</p>
  
  <p>The problem is the server is not having much space to uncompress the file (which requires around 120 gb)</p>
  
  <p>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</p>
  
  <pre><code> gunzip dbdump.sql.gz | mysql -u root -proot123 -S /home/mysql55/tmp/mysql.sock 
  </code></pre>
  
  <p>Is there any way so that i can dump the compressed file without uncompressing it</p>
  
  <p>any suggestions are really grateful</p>