So I installed a new OS (Ubuntu 23.10) and my CQRLOG hasn't been used since Fedora in 2022. Mysql is showing the classic signs of a version mismatch with the native files. I don't have a mysqldump, but I have all the ADIFs from the various backup operations (after each use -- I always answsered yes to backing up).

So I need to somehow set CQRLOG to open with a fresh database so I can import that ADIFs.

Can anyone tell me how to do this? Do I just empty the database directory? Or something else. My mysql.err file ends with:


2023-12-25T02:05:40.959664Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.23.04.1) starting as process 13597
2023-12-25T02:05:40.961025Z 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.
2023-12-25T02:05:40.961035Z 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.
2023-12-25T02:05:41.716195Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1b1eccc4-a2ca-11ee-9330-782bcbaf4f2a.
2023-12-25T02:05:41.744669Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-12-25T02:05:41.744878Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-12-25T02:05:41.744917Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-12-25T02:05:41.745626Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.23.04.1) (Ubuntu).
2023-12-25T02:06:17.431988Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.23.04.1) starting as process 13700
2023-12-25T02:06:17.433158Z 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.
2023-12-25T02:06:17.433168Z 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.
2023-12-25T02:06:17.440667Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-12-25T02:06:17.440795Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-12-25T02:06:17.440815Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-12-25T02:06:17.441188Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.23.04.1) (Ubuntu).
2024-01-18T12:32:35.335382Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.23.04.1) starting as process 42848
2024-01-18T12:32:35.349053Z 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-01-18T12:32:35.349083Z 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-01-18T12:32:36.157109Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-01-18T12:32:36.157321Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-01-18T12:32:36.157363Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-01-18T12:32:36.166892Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.23.04.1) (Ubuntu).


Thanks and 73,
Ed Greenberg
AE2Z