Backup script for Zabbix configuration data (MySQL/PostgreSQL)

This is a MySQL/PostgreSQL database backup script for the Zabbix monitoring software from version 1.3.1 up to 4.4.

Download

Download the latest (stable) release here:

https://github.com/maxhq/zabbix-backup/releases/latest

More informations

Please see the Project Wiki.

Version history

0.9.3 (2020-01-17)

• ENH: Check for unknown tables
• ENH: Speed up MySQL backup by not calling mysqldump for every single table anymore
• ENH: New option -S to specify PostgreSQL schema
• FIX: Stabilize and enhance PostgreSQL dump
• FIX: Skip IP reverse lookup for localhost, fix multiline dig answers

0.9.2 (2020-01-16)

• ENH: Support for Zabbix 4.4
• ENH: Fix (non-critical) shellcheck issues (Mario Trangoni)
• CHG: Fix and enhance helper script get-table-list.pl
• FIX: Escape special characters while reading password (ironbishop)
• FIX: Re-enable accidentally disabled cleanup of postgresql password file
• FIX: Insert hostname into backup file also if database resides on localhost

0.9.1 (2019-03-21)

• FIX: Correctly process hostname option -H (Tiago Cruz)

0.9.0 (2019-03-14)

• NEW: Support for PostgreSQL databases (Sergey Galkin)
• NEW: Option -P to specify database server port (Sergey Galkin)
• NEW: Support for socket connections to MySQL and PostgreSQL server (Greg Cockburn)
• NEW: Database connection parameters are read from Zabbix servern config by default (Greg Cockburn)
• ENH: Support for Zabbix 4.0 (Wesley Schaft)
• ENH: Options -h and --help to show help (hostname is now specified using -H)
• ENH: Options -Z to skip reading the Zabbix server config file
• CHG: Rename script to "zabbix-dump"
• FIX: Support for whitespaces in database parameters (Greg Cockburn)
• FIX: Support for backslashes in manually entered password (Greg Cockburn)

0.8.2 (2016-09-08)

• NEW: Option -x to use XZ instead of GZ for compression (Jonathan Wright)
• NEW: Option -0 for "no compression"
• FIX: Evil space was masking end of here-document (fixed in #8 by @msjmeyer)
• FIX: Prevent "Warning: Using a password on the command line interface can be insecure."

0.8.1 (2016-07-11)

• ENH: Added Zabbix 3.0.x tables to list (added & tested by Ruslan Ohitin)

0.8.0 (2016-01-22)

• FIX: Only invoke dig if available
• ENH: Option -c to use a MySQL config ("options") file (suggested by Daniel Schneller)
• ENH: Option -r to rotate backup files (Daniel Schneller)
• ENH: Add database version to filename if available
• ENH: Add quiet mode. IP reverse lookup optional (Daniel Schneller)
• ENH: Bash related fixes (Misu Moldovan)
• CHG: Default output directory is now $PWD instead of script dir

0.7.1 (2015-01-27)

• NEW: Parsing of commandline arguments implemented
• ENH: Try reverse lookup of IPs and include hostname/IP in filename
• REV: Stop if database password is wrong

0.7.0 (2014-10-02)

• ENH: Complete overhaul to make script work with lots of Zabbix versions

0.6.0 (2014-09-15)

• REV: Updated the table list for use with zabbix v2.2.3

0.5.0 (2013-05-13)

• NEW: Added table list comparison between database and script

0.4.0 (2012-03-02)

• REV: Incorporated mysqldump options (suggested by Jonathan Bayer)

0.3.0 (2012-02-06)

• ENH: Backup of Zabbix 1.9.x / 2.0.0, removed unnecessary use of variables (DATEBIN etc) for commands that use to be in $PATH

0.2.0 (2011-11-05)