Mysql – Upgrade/Transition Path from MySQL Community 5.6.31 to Enterprise

enterprise-editionMySQLupgrade

Full disclosure. I have never upgraded a database. I have a MySQL Community that is not the latest @5.6.31 ( latest is 8 ?) to the paid, Enterprise version. We will ask Tech Support once purchase of Enterprise is fully approved… but really trying to find a clear upgrade path online has proven difficult. I'm a novice, so feel free to be very details in replies.

Best Answer

  1. Upgrade to 5.7. Follow all the steps there, including testing mysql_upgrade.
  2. Test your code against 5.7.
  3. Then embark on upgrading from 5.7 to 8.0; it's more complex but still doable.