Importing zipped files in Mysql using command line

cmd, database, mysql, winzip, xz

Solution

I got the answer from my other question. This is the command to import zipped file when you are using 7zip

7z x -so backup.7z | mysql -u root test

x is the extraction command

`-so` option makes 7-zip write to stdout

Problem

Importing zipped files in Mysql using CMD What is the right syntax to import sql zipped files into mysql using cmd ? I am doing the following ``` xz < backup.sql.gz | mysql -u root test ``` But always getting the following error

Original source

Related problems