mysql suddenly stopped turning on windows11 (2nd time)

[lunarexx]

mysql do not run or turning on xampp v3.3.0 win11 (yesterday ot was):

2022-06-11 15:47:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-06-11 15:47:10 0 [Note] InnoDB: Uses event mutexes
2022-06-11 15:47:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-06-11 15:47:10 0 [Note] InnoDB: Number of pools: 1
2022-06-11 15:47:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-11 15:47:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-06-11 15:47:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-11 15:47:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-11 15:47:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-11 15:47:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-11 15:47:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-06-11 15:47:10 0 [Note] InnoDB: Waiting for purge to start
2022-06-11 15:47:10 0 [Note] InnoDB: 10.4.24 started; log sequence number 16833386; transaction id 41832
2022-06-11 15:47:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-06-11 15:47:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-11 15:47:10 0 [Note] Server socket created on IP: '::'.

[Froosh]

Hmmm. I have Windows 11 Pro and XAMPP 8.16. MySQL and Apache are set to run as Windows Services, and everything works smoothly for me. I've been running 8.1.6 this way since it was released.
Looking at the log fragment above, I do not see any obvious errors or messages. Below is my latest log, which looks similar, other than my log has an extra 5 lines at the end

2022-06-12 8:25:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-06-12 8:25:40 0 [Note] InnoDB: Uses event mutexes
2022-06-12 8:25:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-06-12 8:25:40 0 [Note] InnoDB: Number of pools: 1
2022-06-12 8:25:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-12 8:25:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-06-12 8:25:40 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-12 8:25:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-12 8:25:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-12 8:25:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-12 8:25:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-06-12 8:25:40 0 [Note] InnoDB: Waiting for purge to start
2022-06-12 8:25:40 0 [Note] InnoDB: 10.4.24 started; log sequence number 186743867; transaction id 95012
2022-06-12 8:25:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-12 8:25:40 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-06-12 8:25:40 0 [Note] Server socket created on IP: '::'.
2022-06-12 8:25:40 0 [Note] Reading of all Master_info entries succeeded
2022-06-12 8:25:40 0 [Note] Added new Master_info '' to hash table
2022-06-12 8:25:40 0 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.24-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2022-06-12 8:25:40 0 [Note] InnoDB: Buffer pool(s) load completed at 220612 8:25:40

I know you can launch the database from a command prompt, perhaps that might shed some clues. I don't have the syntax handy, but if you go through the forum posts it is there.

[lunarexx]

I lost my database yesterday, beacuse an advice to restore backup, and it restored empty db. Anyway, I reinstalled xampp, make new installation of software, new database, and today ... the same situation But the log has changed:

2022-06-14 0:03:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-06-14 0:03:38 0 [Note] InnoDB: Uses event mutexes
2022-06-14 0:03:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-06-14 0:03:38 0 [Note] InnoDB: Number of pools: 1
2022-06-14 0:03:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-14 0:03:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-06-14 0:03:38 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-14 0:03:38 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 28619282 between the checkpoint 28619282 and the end 28619264.
2022-06-14 0:03:38 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-06-14 0:03:38 0 [Note] InnoDB: Starting shutdown...
2022-06-14 0:03:38 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-06-14 0:03:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-06-14 0:03:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-14 0:03:38 0 [ERROR] Unknown/unsupported storage engine: InnoDB

Maybe now you can tell me how to repair it. I think it may be connected with hard reset when xampp was running (pc had frozen maybe from mysql)

[Froosh]

I have no idea how to correct that, or what is going on with that. The messages indicate, at least to me, that something is not right with the database files. Are you trying to access the empty database you restored?

But, really, this is beyond me, and what I have experienced. Perhaps others with more knowledge/experience will chime in.

[lunarexx]

Deleting ib_logfile* solves it