Windows 7 extract from .tar and concatenate
Posted on 2012-03-15
I received a .tar MySql backup that has a folder with multiple .gz files. I need to extract each of the .gz mySql.sql files from the .tar and concatenate them. I'm on windows 7 and the Linux command I was provided is:
for file in *.sql.gz; do zcat $file | mysql $YOUR_INTERNAL_NEW_COPY_DB$; done
Hoping someone can translate this to a windows compatible batch or winRar/7Zip command.