Migrating dashboards from 5.0 LTS to 6.0 LTS

[RichardvD]

Hi,

Has anyone any experience with migrating dashboards from 5.0 LTS (5.0.36) to 6.0 LTS (6.0.19).

I already tried the mysqldump to import the dump from 5.0, but too much has changed in 6.0 to directly import it. And I don't want to modify all the lines in the mysqldump file.
So I deviced a python script to extract all the info from the 5.0 server and now I'm stuck in putting the info into the 6.0 server. On the documentation it's stated for the dashboard.create that pages is an array, but I have no clue on what the exact layout of that array in Python should be.

Any help would be appreciated!

Thanks in advance,

Richard

[cyber]

If you upgrade, you should let upgrade processes do the conversion. If you change environment also, clone your 5.0 DB, point your 6.0 install to it and at first startup it should do all the upgrade procedures.

[RichardvD]

If I already have a seperate 6 environment configured, would that still be a feasable scenarion?

[cyber]

Not really, as it needs "old version" to start with... There is a lot of tasks done in DB during upgrade, they need to be in correct order etc...
You can experiment with starting up one more single host server instance and point it to db clone and later copy out data from that converted DB... but it is really trial and error there..

[RichardvD]

Looks like this is working, but I need to do more testing if the conversion is done completely.

[HendrixJax]

Use your Python script to extract dashboard information from your 5.0 server. This could include details like widget configurations, layout, and other relevant metadata.

[RichardvD]

I've already done that, but now I'm stuck on how to upload that info into Zabbix 6. There is no good python example for dashboard.create and I don't know how the layout should be for the pages array parameter

[RichardvD]

I have done the conversion with mysqldump and restoring the DB on the new server, but after this I run into the following problem:

[Z3005] query failed: [1526] Table has no partition for value 1692001766 [insert into history (itemid,clock,ns,value) values (52766,1692001766,168536345,0.63183815787465858),( 53006,1692001766,167166042,2.3012552301255229),(10 1006,1692001766,168612808,99.862098693847656),(140 666,1692001766,169515382,64.949334635575624);

For some reason the partitioning/housekeeping seems to be not working anymore. Any advice would be appreciated.