mysqldump \
--flush-logs \
--single-transaction \
--no-create-info \
--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 | xz > data.sql.xz
mysqldump --flush-logs --single-transaction --no-create-info zabbix history --where=" itemid IN (12345) AND clock > UNIX_TIMESTAMP(NOW() - INTERVAL 10 DAY) " | xz > history.sql.xz
mysqldump --flush-logs --single-transaction --no-create-info zabbix history_uint --where=" itemid IN (12345) AND clock > UNIX_TIMESTAMP(NOW() - INTERVAL 10 DAY) " | xz > history_uint.sql.xz
mysqldump --flush-logs --single-transaction --no-create-info zabbix trends --where=" itemid IN (12345) AND clock > UNIX_TIMESTAMP(NOW() - INTERVAL 10 DAY) " | xz > trends.sql.xz
mysqldump --flush-logs --single-transaction --no-create-info zabbix trends_uint --where=" itemid IN (12345) AND clock > UNIX_TIMESTAMP(NOW() - INTERVAL 10 DAY) " | xz > trends_uint.sql.xz
No comments:
Post a Comment