Solved

Encrypt mysqldump

Posted on 2009-07-09
3
775 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 Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 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

13 Experts available now in Live!

Get 1:1 Help Now