Docker for Windows: MySQL container does not start when migrating from Hyper-v to WSL2

Prerequisites

--I was running Docker for Windows on Hyper-v. --Create a MySQL container in the above environment. --Mount MySQL data files with docker-compose volumes. --Migrate to WSL2 as it is without changing the above specification of MySQL data file. --Other than MySQL, start the container of "PHP: 7.2-apache", "MailHog", "phpmyadmin".

phenomenon

--Containers other than MySQL work normally. --Only MySQL outputs the following log and does not start.

error.log



2020-10-01T19:41:54.887165Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('0').

2020-10-01T19:41:54.887863Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2020-10-01T19:41:54.888441Z 0 [ERROR] [MY-010119] [Server] Aborting

2020-10-01T19:41:55.508831Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL.

Correspondence

--Create a new data folder for MySQL. --Specify the above folder with volumens of docker-compose.

Remarks

――I want to transfer the data as it is, but I'm investigating it. ――For the time being, I was able to operate with the above.

Recommended Posts

Docker for Windows: MySQL container does not start when migrating from Hyper-v to WSL2
WSL2 + Docker Desktop for Windows does not launch only MySQL container
MySQL container does not start in Docker
How to start with Hyper-V instead of WSL2 on Docker Desktop for Windows
[Docker] Does not connect to MySQL workbench ... DB container port forwarding settings
When Docker for Mac 2.4.0.0 does not reflect file changes
Migrating from vargrant to docker
Wait for the container service to start with docker healthcheck
Docker does not work when DOCKER_HOST is specified in WSL2
Notes on character encoding when migrating from windows to Mac
Measures for permissions when building MySQL with Docker on WSL2
Response to WSL2 docker throwing an error after updating Docker for Windows
Docker test DB does not start
Shortcut comparison for those migrating from Eclipse to IntelliJ IDEA (Windows)
Container does not start with docker-compose
Update MySQL from 5.7 to 8.0 with Docker
[Help] Docker for windows 2.3.0.4 without login Service startup method does not work [Help]
Introducing Docker Desktop for Windows on WSL2
Changes when migrating from Spring Boot 1.5 to Spring Boot 2.0
Changes when migrating from Spring Boot 2.0 to Spring Boot 2.2
Precautions when migrating from VB6.0 to JAVA
[NetBeans] Story when it does not start
Error response from daemon: conflict: Conflict when trying to create Docker container, so solution
How to mount the batch file location via WSL2 and start the Docker container
[Grails] Error occurred running What to do when the Grails CLI does not start
I was addicted to not being able to connect to AWS-S3 from the Docker container
What to do when is invalid because it does not start with a'-'
How to get a heapdump from a Docker container
Setting to exit from Docker container with VScode
Copy files from docker container to host (docker cp)
Operate Docker Desktop for Windows on Linux (WSL)
When Kubernetes doesn't start on Docker Desktop for Mac
Localhost3000 does not start up in Docker / Rails development.
Java development for beginners to start from 1-Vol.1-eclipse setup
Docker Compose does not start with docker.credentials.errors.InitializationError error message
Push Docker images from GitHub Actions to GitHub Container Registry
When the server does not start with rails s
When I started ansible + docker now, I stumbled from the beginning, but I managed to start it
What to do when Rails on Docker does not reflect controller changes in the browser