mysql导入压缩文件,使用CMD在Mysql中导入压缩文件

I am trying to import zipped database files into Mysql using command prompt using the following command

7z < backup.sql.7z | mysql -u root test

The root user don't have any password associated with it.

test is my target blank database.

I use 7zip for unzipping purpose.

The zipped database i.e. backup.sql.7z is located in D drive.

But it's giving the following error

So, instead I used the following command

7z < backup.7z | mysql -u root test

Note: This time I am using backup.7z instead of backup.sql.7z

But then I get the following error

Clearly there's something wrong with my SQL syntax.

What will be the correct syntax to use then ?

解决方案

I needed to import from a compressed file as well, and stumbled upon your question.

After a bit of messing around, I found that this worked for me:

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

x is the extraction command

-so makes 7-zip write to stdout