mysqldatabasecmdwinzipxz

Importing zipped files in Mysql using command line

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 enter image description here

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