Zabbix 6.2 mySQL to Zabbix 7.4 Postgresql & Timescale DB Migration Issues

[WirelessGuru]

Hello,

I created a new Zabbix 7.4 Postgresql & Timescale DB. I created an API to export all the following data from the old Zabbix.

actions.json
hosts.json
maps.json
templates.json
value_maps.json
dashboards.json
media_types.json
templates_wrapped.json

The issue I'm having from my script is:[*] Importing templates.json...
[!] Failed to decode JSON response for templates.json:

In anycase, is there any documented process for api bulk export and import operations?

My goal was to effectively bring over all data except for history and trends from the old server.

The DB on the old server was so large that housekeeper effectively failed and it was on an older machine that I could not add any further cpu or memory to support our growth. I wanted to use TimescaleDB for better DB management.

Please advise,

Dan

[Observer365]

Hi, in fact I can't help you with the error you write about, but another approach to reach the goal you declare is to migrate database from MySQL to Postgress with pgloader tool. Because both frontend and backend both use database to get sore and get configuration. I did the migration (but I migrated all tables) referencing this guide. To migrate configuration only you can create pgloader config file where add the line

EXCLUDING TABLE NAMES MATCHING ~/history.*/, ~/trend.*/

.The pgloader dock is here. Just as far as I know you cant migrate db directly from 6.2 to 7.4. You need migrate from 6.2 to 6.2 and than update new server to 7.4.