What's the database preparation process to transfer wordpress from mysql 5.7 to 8

I recently transferred a wordpress site on ubuntu 16.04 with mysql 5.7 to a new droplet using ubuntu 18.04 with mysql 8.0.19, but I simply imported the database from 5.7 to 8.0.19, so my question is if I need to do some sort of conversion, check, or repair to make it compatible with mysql 8? Or simply importing the database is enough? What’s the proper way? Remember that I already transfered the site.


Hi ,

As mysql version upgraded but columns/rows/tables are not. So we also need to upgrade data in database. I believe you need to execute Mysql_Upgrade command to upgrade your data in database.

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

@puneetmysql unfortunately, the Mysql_Upgrade command has been deprecated since version 8.0.16.