Without having made any major changes to the DB, it stopped starting now after I have restarted the computer. The log shows
- Code: Select all
2022-09-23 22:48:40 22952 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2022-09-23 22:48:40 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2022-09-23 22:48:40 0 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.4.21-MariaDB) starting as process 23104 ...
2022-09-23 22:48:40 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2022-09-23 22:48:40 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-23 22:48:40 0 [Note] InnoDB: Uses event mutexes
2022-09-23 22:48:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 22:48:40 0 [Note] InnoDB: Number of pools: 1
2022-09-23 22:48:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 22:48:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-23 22:48:40 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 22:48:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4061302
2022-09-23 22:48:40 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 4061302 between the checkpoint 4061302 and the end 4061311.
2022-09-23 22:48:40 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-09-23 22:48:40 0 [Note] InnoDB: Starting shutdown...
2022-09-23 22:48:40 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-09-23 22:48:40 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-09-23 22:48:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 22:48:40 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-09-23 22:48:40 0 [ERROR] Aborting
2022-09-23 22:48:40 22952 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/MacBook-Pro.local.pid ended
I have already tried to install a fresh version of XAMPP and that launched the mySQL server properly but when I replace the xamppfiles/var/mysql folder with the one from the old XAMPP installation, it crashes again.
Any idea how to fix this?
Max