Hello,
I'd like to ask you guys for your experiences.
I try to migrate zabbix from oracle to mysql.
I did this steps.
Exported : hosts , templates , screens and maps via API and successfully imported.
Via SqlDeveloper I've exported inserts from tables: users, users_group and usrgrp and inserts to mysql was without any problem.
Users and privileges are fine.
I have problem with latest data, graphs.
I have exported sql inserts via sqldeveloper from tables:
trends_uint, trends, history, history_log, history_str, history_text, history_uint
There was couple problems with incompatibility between oracle columns and mysql, but I've fixed this but still I don't see any datas in latest data or graphs.
Did I missed anything? Do anybody of you have experiences with this kind of migration?
I'd like to ask you guys for your experiences.
I try to migrate zabbix from oracle to mysql.
I did this steps.
Exported : hosts , templates , screens and maps via API and successfully imported.
Via SqlDeveloper I've exported inserts from tables: users, users_group and usrgrp and inserts to mysql was without any problem.
Users and privileges are fine.
I have problem with latest data, graphs.
I have exported sql inserts via sqldeveloper from tables:
trends_uint, trends, history, history_log, history_str, history_text, history_uint
There was couple problems with incompatibility between oracle columns and mysql, but I've fixed this but still I don't see any datas in latest data or graphs.
Did I missed anything? Do anybody of you have experiences with this kind of migration?