Liked nioakeim’s post in the thread Icinga2 IDO pgsql database / Icinga Reporting Questions-Issues.Like (Post)To save some time on others who wish to migrate icinga from postgres to mysql, these are the steps that i followed.
Dump your current icinga postgres db:
(Code, 1 line)
Modify your dump to comment out all postgres specific lines
(Code, 3 lines)