Daily backup for Zabbix raw history data

mysqldump \
--flush-logs \
--single-transaction \
--no-create-info \
zabbix history --where=" \
clock >= UNIX_TIMESTAMP(\"$(date -d "2 DAY AGO" "+%Y-%m-%d 00:00:00")\") \
AND \
clock < UNIX_TIMESTAMP(\"$(date -d "1 DAY AGO" "+%Y-%m-%d 00:00:00")\") \
" > history.sql.$(date -d "2 DAY AGO" "+%Y-%m-%d")

With compression:

mysqldump \
--flush-logs \
--single-transaction \
--no-create-info \
zabbix history --where=" \
clock >= UNIX_TIMESTAMP(\"$(date -d "2 DAY AGO" "+%Y-%m-%d 00:00:00")\") \
AND \
clock < UNIX_TIMESTAMP(\"$(date -d "1 DAY AGO" "+%Y-%m-%d 00:00:00")\") \
" | xz > history.sql.xz.$(date -d "2 DAY AGO" "+%Y-%m-%d")