Solved

Encrypt mysqldump

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Creating and Managing Databases with phpMyAdmin in cPanel.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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