Requirements

Tested on

mysqldump-secure has been sucessfully tested on the following operating systems:

FreeBSD RedHat CentOS Debian ArchLinux Ubuntu OSX

Required tools

mysqldump-secure will automatically check if all required software for its current run-time configuration is installed and complain verbosely about missing stuff.

The following tools are generally required or optionally required:

Program Required Description
mysql yes The mysql binary is used to find all available databases and their corresponding size
mysqldump yes This is used for the actual dump procedure
openssl optional Optionally used for private/public key encrypting the database dump
gzip optional Optionally used for compressing the database dump
pigz optional Optionally used for compressing the database dump (multithreaded)
bzip2 optional Optionally used for compressing the database dump
pbzip2 optional Optionally used for compressing the database dump (multithreaded)
xz optional Optionally used for compressing the database dump
lzma optional Optionally used for compressing the database dump
lzop optional Optionally used for compressing the database dump
tmpwatch optional Optionally used to delete old database dumps
tmpreaper optional Optionally used to delete old database dumps
check_mysqldump-secure optional Optionally used to monitor the dump via nagios (already bundled as a submodule inside this repository)

For a comparison about which compression algorithm to chose, have a look at the compression performance benchmark.