Importing zipped files in Mysql using command line
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.
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.
Doing the following in a command prompt works for me, also adding to my User environment variables worked fine as well: set PATH=%PATH%;C:\Program Files\7-Zip\ echo %PATH% 7z You should see as output (or something similar – as this is on my laptop running Windows 7): C:\Users\Phillip>set PATH=%PATH%;C:\Program Files\7-Zip\ C:\Users\Phillip>echo %PATH% C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program … Read more