Zabbix server. Move item from host to host, keeping old data

Question

System administration

Prompt, please. The situation is as follows: there were two hosts with mysql server Host1 and Host2. At one point, there was a need to transfer the db1 database from host1 to host2. Copying db1 to host2 was done. How can I move a data item from host1 to host2 while keeping the old data?

Answer 1

Thank you. Got my question answered serverfault.com/questions/519239/how-can-transfer-zabbix-item-from-different-hosts-and-save-item-statistic?noredirect=1#comment589342_519239

Answer 2

You can use the database administration tools:
- For example, for windows (client), the navicat program is good (for a fee, or use a duck). I recommend for a competent GUI + functionality.
-PhpMyAdmin will help you for free, you can backup your database and extract the data you need (there may be separate tables) elsewhere.
-You can also read how you can make a backup manually from the console, no additional programs were needed, except for mysqlclient, which is already installed with the server if you have a Unix system.