I’m in the process to transfer a wordpress site to a new droplet which uses an older version of mysql 5.7.23. I want to start with a clean install a database, so only the necessary tables will come to the new database, but the old server is using mysql 8.0.19. Can I import tables from mysql 8.0.19 to a database using an older mysql 5.7? If yes, do I need to do anything beside importing the mysqldump?
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.
Click below to sign up and get $100 of credit to try our products over 60 days!