Move history from one item to another

[vanyadog]

Hello.
i found host id

mysql> select hostid, host from hosts;
|  13032 | test
|  13033 | test2

i found item id for each hosts

mysql> select itemid, name  from items where hostid = 13032;
+--------+--------------------+
| itemid | name               |
+--------+--------------------+
| 502778 | ICMP ping          |
| 502779 | ICMP loss          |
| 502780 | ICMP response time |
| 502772 | System Temp        |
| 502773 | CPU1 Temp          |
| 502774 | CPU2 Temp          |
| 502775 | PCH Temp           |
| 502776 | Peripheral Temp    |
| 502777 | VBAT               |
+--------+--------------------+
9 rows in set (0.00 sec)

mysql> select itemid, name  from items where hostid = 13033;
+--------+--------------------+
| itemid | name               |
+--------+--------------------+
| 502787 | ICMP ping          |
| 502788 | ICMP loss          |
| 502789 | ICMP response time |
| 502781 | System Temp        |
| 502782 | CPU1 Temp          |
| 502783 | CPU2 Temp          |
| 502784 | PCH Temp           |
| 502785 | Peripheral Temp    |
| 502786 | VBAT               |
+--------+--------------------+
9 rows in set (0.00 sec)

i tryed to move history for CPU2 Temp from test to test2

UPDATE history SET itemid = 502783 WHERE itemid = 502774;

mysql> UPDATE history SET itemid = 502783 WHERE itemid = 502774;
Query OK, 377497 rows affected (12 min 54.16 sec)
Rows matched: 377497  Changed: 377497  Warnings: 0

a part of history was transferred and other part was not

I use partitioning for mysql

Have I done something wrong?
Could you explain me how to move history correctly? How about trends?

Thanks

[kloczek]

You need to do the same for trends* tables data.
Zabbix adds trends point basing only on last hour data so when history* tables data will be expired by dropping oldest history* tables partitions your item data will be with trends data from before history table update query.
When you are switching to view monitoring data to longer time scale zabbix web frontend automatically switches to present not history data but those from trends* tables and this you see that at some point you don't see not updated data.

[vanyadog]

Ok, it's clear. Thanks.
How about problems|triggers|events?
I mean... for example 2 month ago CPU temperature was high and trigger "told" me about that. Now I can't see that in Monitoring->Problems

[kloczek]

I'm not going to describe whole set of such changes because I never done such migration.
Nevertheless if you are reusing the same HW to install new system instead moving all host data to new monitored host you should just change host interface (hostname/IP).