I have currently running Zabbix 3.0.24 on Ubuntu 14.04 on XCP-ng 7.6.
I wanted to upgrade to Ubuntu 18.04. So reading a few guides posted by members. I have created a new VM with Ubuntu 18.04 and installed the same version of Zabbix. However I noticed that mysql is now 5.7 instead of 5.5. The question now is how do I migrate the database across versions of mysql. I understand the question is not strictly a Zabbix question however since Zabbix is reliant on this database. I thought it would be best to post this question here.
I wanted to upgrade to Ubuntu 18.04. So reading a few guides posted by members. I have created a new VM with Ubuntu 18.04 and installed the same version of Zabbix. However I noticed that mysql is now 5.7 instead of 5.5. The question now is how do I migrate the database across versions of mysql. I understand the question is not strictly a Zabbix question however since Zabbix is reliant on this database. I thought it would be best to post this question here.
Comment