Mysqldump-secure is a POSIX compliant wrapper script for
mysqldump with encryption capabilities and strong security in mind. It will backup every available database (transaction-safe across tables) as a separate file with the possibility to opt out via blacklisting. Dumped databases can optionally be on-the-fly compressed (
pbzip2, etc) as well as encrypted with
openssl assymetric encryption (no password needed). Compression and encryption is done before the file is written to disk to avoid possible race conditions.
Apart from that
mysqldump-secure is able to apply conditional dump options to each database separately by inspecting certain metrics such as size and table engines prior dumping.
Other features include:
log4j based log levels,
slave recognition and completely self-validating, meaning if anything goes wrong, it will tell you what went wrong and how to fix it.
mysqldump-secure is like
mysqldump on steroids.
mysqldump-secure 0.16.2 released
mysqldump-secure 0.16.1 released
See travis-ci for builds and live usage. Just click on the image below to see the travis-ci builds.
Easy integration into Nagios or Icinga.
Get running within 30 seconds.
$ wget https://github.com/cytopia/mysqldump-secure/archive/0.16.3.tar.gz -O - | tar -xz
$ cd mysqldump-secure
$ sudo make install
# Fix file permissions, create folders and check connectivity
$ sudo mysqldump-secure --test