1.Run MySQL container (if not running)

docker run --name my-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -p 3306:3306 -d mysql:8


Dump (export)

docker exec my-mysql mysqldump -u root -pmy-secret-pw diva > diva.sql

docker exec my-mysql mysqldump -u root -pmy-secret-pw kwazinto > kwazinto.sql


docker exec my-mysql mysqldump -u root -pmy-secret-pw eventique > eventique.sql


IMPORT
docker exec -i my-mysql mysql -u root -pmy-secret-pw diva < diva1July.sql


2. Check running containers
docker ps

then:

3. start mysql
docker start my-mysql


4. Connect to MySQL inside the container
docker exec -it my-mysql mysql -uroot -p


Password is: my-secret-pw

5. Stop MySQL container
docker stop my-mysql


DUMP

docker exec my-mysql mysqldump -u root -pmy-secret-pw lapeng > lapeng3Feb.sql
https://meet.google.com/bzo-gnei-uwa