Importing zipped files in Mysql using command line

Question

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

Kanuj Bhatnagar · Answer 1 · 2016-05-05T10:21:17.277

77

Try:

unzip -p dbdump.sql.zip | mysql -u root -p yourdbname

The dbdump.sql.zip should contain a single SQL file. The -p flag pipes the output into the mysql binary.

edited May 05 '16 at 10:21

answered Nov 12 '15 at 06:54

Kanuj Bhatnagar

you must have installed unzip, you can install unzip, if not installed. `sudo apt-get install unzip` – Allahbakash.G Dec 11 '19 at 14:04
1

@Allahbakash.G - yes, I did have unzip installed... the OP's question did say that their file was **zipped**. – Kanuj Bhatnagar Dec 16 '19 at 10:11
yeah, while using unzip command in the new ubuntu machine, I had got an error, saying unzip is not installed. – Allahbakash.G Dec 17 '19 at 10:51

score 20 · Accepted Answer · edited Jun 23 '14 at 13:48

20

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

edited Jun 23 '14 at 13:48

superjos

answered Aug 28 '12 at 06:55

Subrata

thanks, but it worked for me if -u and username, -p and password, dont have space, hence, 7z x -so backup.7z | mysql -umysqlusername -pmysqlpassword dbname, thx for the hint – Agung Sagita Feb 06 '20 at 05:30

score 16 · Answer 3 · edited Apr 29 '14 at 14:20

16

zcat backup.sql.gz | mysql -u[username] -p[pswd] [db]

edited Apr 29 '14 at 14:20

slavoo

answered Apr 29 '14 at 14:03

davev

score 0 · Answer 4 · answered Jun 29 '12 at 18:46

0

You want might to try xz −−decompress −−stdout to decompress.

Full command would be xz −−decompress −−stdout backup.sql.gz | mysql -u root test

answered Jun 29 '12 at 18:46

ESG

1

It's showing an error like-> **xz: backup.sql.zip: File format not recognized** – Subrata Jun 29 '12 at 19:02
1

xz doesn't seem to support zip files. Only xc and lzma formats. – ESG Jun 29 '12 at 19:56
1

Yes, I use it for 7z archives. Should work fine with zip files too. My command line looks like `7z.exe e -y -so current.7z` – ESG Jun 29 '12 at 20:48

4 Answers4