[SOLVED] How do I import data from a mysql 5.7 docker container into a mysql 8.0 docker container?

Issue

Currently my database is stored on a Mysql 5.7 docker container, now I have created a new Mysql 8.0 container, I want to export the contents of the database in the Mysql 5.7 docker container and import it into the Mysql 8.0 container, I will use the Mysql 8.0 container in the future, how should I do this? What are the exact steps to do this?

Solution

1.use some tools,for example Navicat

2.use mysql backup ways dump，and you can skip information_schema, mysql, performance_schema, sys.

Answered By – dogs Cute

Answer Checked By – Gilberto Lyons (BugsFixing Admin)