Migrating Zabbix database config Data

[vlam]

Hi

I need to migrate my Zabbix from version 2.4.6 to version 3.0 and to new hardware but I have a small problem of my database being almost 700GB in size. So my problem is to do a dump and then a restore of the entire database will take to long. So I need to know is there a way of only doing a dump of the configuration components (Hosts, Host Groups, User & Group, Templates, all relevant configuration detail). Is this possible and if so how will I go about in doing it.

The plan is to keep the old DB just for history and report purposes and then start a new DB from Scratch.

Any help will be greatly appreciated.

Thanks

[jan.garaj]

https://www.zabbix.org/wiki/Docs/how..._backup_script - you can backup/restore only config data.

[kloczek]

Hi

I need to migrate my Zabbix from version 2.4.6 to version 3.0 and to new hardware but I have a small problem of my database being almost 700GB in size. So my problem is to do a dump and then a restore of the entire database will take to long. So I need to know is there a way of only doing a dump of the configuration components (Hosts, Host Groups, User & Group, Templates, all relevant configuration detail). Is this possible and if so how will I go about in doing it.

The plan is to keep the old DB just for history and report purposes and then start a new DB from Scratch.

If one of your DB nodes is slave database you can simple use this db t omake upgrade without copy/dump->restore database.

Just:
- stop DB on slave
- remove mater.info and all binary logs
- start database
- do upgrade zabbix server and proxies (agents can be upgraded later)

If something will be wrong you still would be able to use original master and after downgrade zabbix server and proxies you still will be able to work.

Last step after successful upgrade will be regenerate new slave on prev master from cold database binary snapshot.

So again: you don't need copy any data