Requirements
Tested on
mysqldump-secure has been sucessfully tested on the following operating systems:
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.