--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".
--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.
--Create a new data folder for MySQL. --Specify the above folder with volumens of docker-compose.
――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