can't find database data directory after upgrade from ubuntu 22.04 to 24.04

3 posts / 0 new
Last post
ON7LG
can't find database data directory after upgrade from ubuntu 22.04 to 24.04

Hi,

After upgrading from ubuntu 22.04 to 24.04 I can't acces my database files any more.
here's the last lines of the error log:, hope this helps...
Thanks in advance,
Geert

2024-09-06T12:42:53.224667Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39-0ubuntu0.24.04.2) starting as process 3360
2024-09-06T12:42:53.233943Z 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.
2024-09-06T12:42:53.233954Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-09-06T12:42:53.303857Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-09-06T12:42:53.304913Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-09-06T12:42:53.304954Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-06T12:42:53.308251Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39-0ubuntu0.24.04.2) (Ubuntu).

oh1kh
can't find database data directory after upgrade from ubuntu 22.

HI!
Classic problem with Ubuntus.
You have mysql sql server installed. You should install MariaDB instead. That will override Mysql installation.
Install MariaDB server, client and common. You find related messages with Google using search words:
cqrlog.com mariadb install

--
Saku
OH1KH

ON7LG
All working!

Hi Saku,
I installed mariadb as you suggested and all works like a charm now!
Thank you so much!
73 ON7LG, Geert