One line unzip and mysql dump to database

May 25, 2009    database dump export import Mysql Development php phpmyadmin

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 mydb.zip | mysql -u USER -pPASS -D dbname

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

Hope this is helpful!


blog comments powered by Disqus