I have a recent.sql.gz file on a remote server. What I try to accomplish is the following: I want to open the file, push the content over SSH to my local machine, use zcat to uncompress the content and pipe it to mysql. Something like this:ssh user@remote 'cat recent.sql.gz' | zcat | mysql
Get contents of a .gz file over SSH and pipe it to zcat and mysql
ssh;cat