Backup Zabbix database (3.0 or 4.0) without history & trends, MySQL

5.0 data only (must import schema.sql first):
mysqldump \
--flush-logs \
--single-transaction \
--no-create-info \
--ignore-table=zabbix.acknowledges \
--ignore-table=zabbix.alerts \
--ignore-table=zabbix.auditlog \
--ignore-table=zabbix.auditlog_details \
--ignore-table=zabbix.escalations \
--ignore-table=zabbix.events \
--ignore-table=zabbix.history \
--ignore-table=zabbix.history_log \
--ignore-table=zabbix.history_str \
--ignore-table=zabbix.history_sync \
--ignore-table=zabbix.history_text \
--ignore-table=zabbix.history_uint \
--ignore-table=zabbix.profiles \
--ignore-table=zabbix.service_alarms \
--ignore-table=zabbix.sessions \
--ignore-table=zabbix.trends \
--ignore-table=zabbix.trends_uint \
zabbix | gzip > data.sql.gz
To see which tables to exclude on older version see the very bottom of page:
https://github.com/maxhq/zabbix-backup/blob/master/zabbix-dump
and search for keywork "SCHEMAONLY"

For 2.4 just to test updade (cut escalations part):
sudo mysqldump \
--flush-logs \
--single-transaction \
--create-options \
--ignore-table=zabbix.acknowledges \
--ignore-table=zabbix.alerts \
--ignore-table=zabbix.auditlog \
--ignore-table=zabbix.auditlog_details \
--ignore-table=zabbix.escalations \
--ignore-table=zabbix.events \
--ignore-table=zabbix.history \
--ignore-table=zabbix.history_log \
--ignore-table=zabbix.history_str \
--ignore-table=zabbix.history_text \
--ignore-table=zabbix.history_uint \
--ignore-table=zabbix.profiles \
--ignore-table=zabbix.service_alarms \
--ignore-table=zabbix.sessions \
--ignore-table=zabbix.trends \
--ignore-table=zabbix.trends_uint \
--ignore-table=zabbix.user_history zabbix | gzip --fast > ~/conf.only.without.escalations.gz
Backup only the configuration (suitable for 3.0 and 4.0:
#!/bin/bash
sudo mysqldump \
--flush-logs \
--single-transaction \
--create-options \
--ignore-table=zabbix.acknowledges \
--ignore-table=zabbix.alerts \
--ignore-table=zabbix.auditlog \
--ignore-table=zabbix.auditlog_details \
--ignore-table=zabbix.escalations \
--ignore-table=zabbix.events \
--ignore-table=zabbix.history \
--ignore-table=zabbix.history_log \
--ignore-table=zabbix.history_str \
--ignore-table=zabbix.history_str_sync \
--ignore-table=zabbix.history_sync \
--ignore-table=zabbix.history_text \
--ignore-table=zabbix.history_uint \
--ignore-table=zabbix.history_uint_sync \
--ignore-table=zabbix.profiles \
--ignore-table=zabbix.service_alarms \
--ignore-table=zabbix.sessions \
--ignore-table=zabbix.trends \
--ignore-table=zabbix.trends_uint \
--ignore-table=zabbix.user_history \
--ignore-table=zabbix.node_cksum zabbix | gzip  > /root/conf.only.gz
Backup all except all 7 biggest tables (history, history_log, history_str, history_text, history_uint, trends, trends_uint):
#!/bin/bash
time=$(date +%Y%m%d%H%M)
echo creating backup of config, events, trigger history..
mysqldump -hlocalhost -uroot -ppQtg3kqq5S9PGFGC \
--flush-logs \
--single-transaction \
--create-options \
--ignore-table=zabbix.history \
--ignore-table=zabbix.history_log \
--ignore-table=zabbix.history_str \
--ignore-table=zabbix.history_text \
--ignore-table=zabbix.history_uint \
--ignore-table=zabbix.trends \
--ignore-table=zabbix.trends_uint zabbix | gzip > /root/$time.without.history.tables.sql.gz
Backup all:
#!/bin/bash
time=$(date +%Y%m%d%H%M)
echo creating backup of config, events, trigger history..
mysqldump -hlocalhost -uroot -ppQtg3kqq5S9PGFGC \
--flush-logs \
--single-transaction \
--create-options \
zabbix | gzip > /root/$time.all.sql.gz
Restore:
yum -y install bzip2
mysql -uzabbix -p
drop database zabbix;
CREATE DATABASE zabbix CHARACTER SET UTF8 collate utf8_bin;
GRANT ALL PRIVILEGES on zabbix.* to "zabbix"@"localhost" IDENTIFIED BY "zabbix";
quit
bzcat dbdump.bz2 | sudo mysql -uzabbix -pzabbix zabbix
Backup biggest tables:
cd
time=$(date +%Y%m%d%H%M)
mysqldump -uroot -p --flush-logs --single-transaction --no-create-db --no-create-info zabbix history_uint | bzip2 -9 > $time.history_uint.bz2
mysqldump -uroot -p --flush-logs --single-transaction --no-create-db --no-create-info zabbix history_log | bzip2 -9 > $time.history_log.bz2
mysqldump -uroot -p --flush-logs --single-transaction --no-create-db --no-create-info zabbix history_str | bzip2 -9 > $time.history_str.bz2
mysqldump -uroot -p --flush-logs --single-transaction --no-create-db --no-create-info zabbix history_text | bzip2 -9 > $time.history_text.bz2
mysqldump -uroot -p --flush-logs --single-transaction --no-create-db --no-create-info zabbix history | bzip2 -9 > $time.history.bz2
mysqldump -uroot -p --flush-logs --single-transaction --no-create-db --no-create-info zabbix trends | bzip2 -9 > $time.trends.bz2
mysqldump -uroot -p --flush-logs --single-transaction --no-create-db --no-create-info zabbix trends_uint | bzip2 -9 > $time.trends_uint.bz2
ls -l $time*
Byat