Note-to-self:
- Create hosts to the new instance with items you want to monitor
- Map itemids between instances to specify item data you want to copy from the old instance
- Copy history(_log,_str,_text, _uint)- and trends(_uint) data, enjoy:
- INSERT INTO zabbix2.history (itemid,clock,value,ns) SELECT ‘25188’,clock,value,ns FROM zabbix1.history WHERE itemid=’90090000000025470′;
- INSERT IGNORE INTO zabbix2.trends (itemid,clock,num,value_min,value_avg,value_max) SELECT ‘25188’,clock,num,value_min,value_avg,value_max FROM zabbix1.trends where itemid=’90090000000025470′;