How to merge Zabbix databases?

[filosmith]

Hi, I am in a situation where I need to merge two Zabbix MySQL databases into one. Is this possible?

I have tried bulk loads before but the server doesn't seem to check the database before assigning IDs to entities; My bulk load would create entities, incrementing the ID numbers, but then when I added an item through the gui, it didn't realize that the ID was already taken. I don't recall if it was hostid or itemid.

So, I have a complete Zabbix master with history that I need to merge into a second master gracefully.

Thanks

[mbsit]

Hi
The only "nice" solution I see is, to utilize zabbix_sender tool.

You have to create all items in "target" database manually (or zabbixa api). Then replace in "history*" tables in "source" database all iditems to that one zabbix assign.

Then read from "source" database and put into "target" database by zabbix_sender.

Bests,
Grzegorz