Welcome, Guest
Username: Password: Remember me
Ultra Web Server Elements discussions and problems.
  • Page:
  • 1

TOPIC:

Error on MySQL-08_00_20_00 - mysqld "dies" 3 years 11 months ago #14675

  • Henry
  • Henry's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 3
  • Thank you received: 0
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.

Error on MySQL-08_00_20_00 - mysqld "dies" 3 years 11 months ago #14676

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4510
  • Thank you received: 1100
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

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

Last edit: by Sternas Stefanos.
  • Page:
  • 1