Solved

Encrypt mysqldump

Posted on 2009-07-09
3
779 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now