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.×