Solved

Encrypt mysqldump

Posted on 2009-07-09
3
786 Views
Last Modified: 2012-06-27
I am currently creating mysqldump files and automatically Gzipping them which works very well.

However, Gzip doesn't seem to be able to password protect a file.  Is there another application that can zip and encrypt the dump all in one operation?

I was using Winzip command line which works, but I have to do the dump and then zip which takes ages.

Note that this is a Windows server.
0
Comment
Question by:Orroland
  • 2
3 Comments
 
LVL 33

Expert Comment

by:snoyes_jw
ID: 24813137
GPG. The Windows port is http://www.gpg4win.org/
0
 

Author Comment

by:Orroland
ID: 24813344
How would this work?  Can you give an example?
0
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 500 total points
ID: 24813565
Probably something like this:

mysqldump <options> | gpg --passphrase <password> -e -

Read gpg's manual for details and all options.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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