unzip -p dbdump.sql.zip | mysql -u root -p dbname
Note
-p flag pipes the output.
Make sure the zip file contains only a single sql file.
Make sure to change dbname to the name of your database on the MySQL server.
Import zipped mysql dumps
Stanislav Khromov
Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
LinkedIn
Twitter
WordPress.org Profile
Visit my other blog
Comments
3
-
Posted on
Konka
Bro Any possibility of importing zipped XLSV files to DB and to extract data from zipped XLSV files.
-
Posted on
That’s a whole different beast. You’d have to find a command line utility that can perform XLSV -> SQL conversion.
-
ТRАNSFЕR 1,00387 BТС. Confirm >> https://script.google.com/macros/s/AKfycbwR8rrd886wqqh7kJsOaCf_Mdxckxx9ywDLBdGE2K6zcvCF2U3tAffOcPIOABnPfr5Vxg/exec?hs=c19fcf4a265162b1885d60a885d6d568&