More stable, versatile and chic ;-)
Happy New Year!
The script and the help page have been refined and there are new options.
It should now be usable for both command line and scripting (invoked by other scripts).
Due to #!/usr/bin/env bashit should also work on BSD etc.
Direct script download: zabbix-mysql-dump (v0.8.0)
New options
-c FILE
Use FILE for MySQL options (passed via --defaults-extra-file).
PLEASE NOTE:
mysqldump needs the database to be specified via command line.
So the first "database" options found in the config file is
used for mysqldump.
-r NUM
Rotate backups while keeping up to NUM generations.
Uses filename to match.
Default: keep all backups
-n
Skip reverse lookup of IP address for host.
-q
Quiet mode: no output except for errors (for batch/crontab use).
Changelog for version 0.8.0 (2016-01-22)
- New option -c to use MySQL config file for credentials etc. (idea by @dschneller)
- New option -r to rotate backup files (#3 by @dschneller)
- New option -q for quiet mode (#3 by @dschneller)
- New option -n for suppressing reverse IP lookup (#3 by @dschneller)
- Include Zabbix database version in dump filename
- Default output is now the current working directory instead of the script directory
- Script should now also run when invoked by other scripts (#4 by @dumol)
Thanks!
I want to say sorry for the long delay and thank you to all code and comment contributors: