Import zipped mysql dumps

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.

unzip manpage

2 thoughts on “Import zipped mysql dumps

    1. Stanislav Khromov Post author

      That’s a whole different beast. You’d have to find a command line utility that can perform XLSV -> SQL conversion.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Markdown is allowed in comments.