Skip to content

Instantly share code, notes, and snippets.

@flisky
Last active August 29, 2015 14:17
Show Gist options
  • Save flisky/a3af7bc9273c9b3b49b9 to your computer and use it in GitHub Desktop.
Save flisky/a3af7bc9273c9b3b49b9 to your computer and use it in GitHub Desktop.
zabbix database dump with config data only
mysqldump --single-transaction --no-create-info \
--ignore-table zabbix.history \
--ignore-table zabbix.history_str \
--ignore-table zabbix.history_log \
--ignore-table zabbix.history_uint \
--ignore-table zabbix.history_text \
--ignore-table zabbix.trends \
--ignore-table zabbix.trends_uint \
--ignore-table zabbix.auditlog \
--ignore-table zabbix.auditlog_details \
--ignore-table zabbix.events \
--ignore-table zabbix.alerts \
-uroot zabbix
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment