Forum
× Ultra Web Server Elements discussions and problems.

Question Error on MySQL-08_00_20_00 - mysqld "dies"

  • Henry
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 weeks 2 days ago #14675 by Henry
Hello.
Installing MySQL 8 on my UWS for the 1st time (MySQL-08_00_20_00), the mysqld always "dies" with the following error messages (the warning about the character set can be easily fixed):

2020-05-05T18:13:03.675228Z 0 [System] [MY-010116] [Server] C:\UltraWebServer\core\mysql80\bin\mysqld.exe (mysqld 8.0.20) starting as process 28984
2020-05-05T18:13:03.681135Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2020-05-05T18:13:03.742546Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-05-05T18:13:03.746639Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-05-05T18:13:03.752877Z 0 [ERROR] [MY-010119] [Server] Aborting

2020-05-05T18:13:03.757263Z 0 [System] [MY-010910] [Server] C:\UltraWebServer\core\mysql80\bin\mysqld.exe: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.


No need to say that folder c:\UltraWebServer\core\mysql80\data\ is correctly in place with its contents.

It does not happen with MySQL 5.x
How can i fix it?

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 weeks 2 days ago - 3 weeks 2 days ago #14676 by Sternas Stefanos
Replied by Sternas Stefanos on topic Error on MySQL-08_00_20_00 - mysqld "dies"
Sir
MySQL 8 and MySQL 5.x are NOT the same.
MySQL 8 it's totally new database.
MySQL 8 has DATA Auto Update Ability.

My Suggestion
Try to convert your data from 5.6 to
uws03w_MySQL-05_06_48_00 with (Manual DATA Update)
then to
uws03w_MySQL-05_07_30_00 with (Manual DATA Update)
then to MySQL-08

Test and
uws03w_MySQL-08_00_17_00
uws03w_MySQL-08_00_18_00
uws03w_MySQL-08_00_19_00

PS: We can't give support to Database Administration level.

PilotLogic Architect and Core Programmer
Last edit: 3 weeks 2 days ago by Sternas Stefanos.

Please Log in or Create an account to join the conversation.