One line unzip and mysql dump to database

May 25, 2009

After some advice on my last post I thought id make another post with a revised version of my other post about the same topic.

unzip -p | mysql -u USER -pPASS -D dbname

This one line will do the job of unzipping a file on your remote server to the database of your choice.

Hope this is helpful!

About me

Hello! I'm David Heward, how are you going? I'm a Senior Devops/Build Engineer, specialising in AWS & Cloud Automation. Based in London. Strong 10+ year background in Software development. Have a read of my blog. Have a look at some of my working projects. Contact me at @davehewy or on Linkedin.