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.

  • 1
    Seems like direct 5.6 to 8 is not supported - I'd wait and take advantage of the product support you're paying for. – LowlyDBA Jan 21 '19 at 16:26
  • 1
    like @LowlyDBA said i think the safe way is is to install MySQL 8 on a other directory leave the MySQL 5.6 as it is for now.. Make a .sql dump from the MySQL 5.6 and import it on MySQL 8.0.. Test/Compare the tables and data between MySQL 5.6 before removing MySQL 5.6.. This feels like the most safe way.. – Raymond Nijland Jan 21 '19 at 16:29
  • Once you’ve paid for Enterprise you can log a ticket with Oracle Support and they will walk you through it. As Rick James mentioned the upgrade path is to step onto each major release between your old and destination versions. The trick with upgrades is to ensure your application both works and provides an acceptable performance level for your users before you commit to the change. It’s hard/time consuming to rollback major upgrades when all your eggs are in one basket. – eroomydna Jan 22 '19 at 10:30
  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.
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.