Question
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.
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.
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
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.