Import MYSQL 5.6 to New MYSQL 5.7 DB

Nix4Life
Valued Contributor

Hi Guys, Looking to move our mysql 5.6 db to a standalone machine. I am thinking this is a good time to move to mysql 5.7. Has anyone imported a 5.6 mysql backup into a fresh 5.7 mysql db? if so any gotchas?

tia

Larry

2 REPLIES 2

mpermann
Valued Contributor II

@LSinNY I went from JSS 9.97 on Ubuntu 12.04 with Java 1.7.0_121, Tomcat 7.0.52 and MySQL 5.5.54 to JSS 9.98 on Ubuntu 16.0.4 with Java 1.8, MySQL 5.7.x and Tomcat 8.0.x without any problems. A tech from Jamf Support said it was ok to do and pointed me here for information on how to do it. The only mistake I made was forgetting to modify the DataBase.xml file before starting things. I use the manual install process so I needed to edit some files and simply forgot to edit the DataBase.xml file. Otherwise the process went very smoothly and worked fine. I would encourage you to do this on a test environment before you do it on your production system.

Nix4Life
Valued Contributor

Thanks @mpermann