Solved

Windows 7 extract from .tar and concatenate

Posted on 2012-03-15
5
656 Views
Last Modified: 2012-04-26
Hi,

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.

Thx,
Fred
0
Comment
Question by:fredjonzeTwo
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Geisrud
ID: 37726790
I recently used "Peazip" to work with a .tar.gz file successfully.  The site lists split/join files as a feature, though I haven't used it.  Hope that helps.

http://www.peazip.org/download-installer-p-windows.html
0
 
LVL 14

Expert Comment

by:Geisrud
ID: 37757531
Were you able to try the Peazip feature I mentioned?
0
 

Accepted Solution

by:
fredjonzeTwo earned 0 total points
ID: 37757551
I did try Peazip. The join function does not appear to be appropriate for the use I need. What I had to end up doing was extracting the 200+ separate .gz MySql tables to a directory and then use a dos command to concatenate them all. Not the one command solution I was looking for that appears to be usable in Linux.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question