We want to upgrade to MySQL 8.0 from MySQL 5.6 but upgrade manual seems to cumbersome and risky to follow doing an in-place upgrade so we have decided to do it via MySQL Workbench export (mysqldump) and import our exported database tables into a fresh new MySQL 8.0 installation

Should it be successful or should we do something else in the middle for it to work?

  • 1
    If you have the resources, just try it on a secondary, non-Production server and see what happens! Jan 18, 2021 at 17:13
  • 2
    check the upgrade path that mysql shows you first from 5.6 to 5.7 and then to 8.0.22 otherwise you will end up in a lot of trouble
    – nbk
    Jan 18, 2021 at 17:43

1 Answer 1


Step 1 :

It's a best practise that first to upgrade MySQL 5.6 to MySQL 5.7, then from MySQL 5.7 to MySQL 8.0.

Step 2 :

Please go through MySQL 8.0 changelog to take changes in your database for deprecated & removed features otherwise upgrade end up in so many errors


Step 3 :

Before, upgrading to MySQL 8.0, run upgrade checker trail using mysqlshell.

mysqlsh [email protected]:3306 -e "util.checkForServerUpgrade();" > upgrade_alert.txt

Step 4 :

Final step for upgrade should be done logical only to avoid errors in inplace upgrade.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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