SQL cannot be started

[iqbit]

Hello, I last used SQL/Apache last week and I didn't have any problems. Today, while the Apache server started normally, MySQL crashed immediately after startup and gave me an error message. I can't access PHPMyAdmin anymore, so is there 1) a way to back up my data and 2) a way to fix the problem? Restarting my computer and turning off the firewall didn't help, and it is running as an administrator.
MySQL log:

Code: Select all

2024-01-25 12:02:26 2 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2024-01-25 12:02:26 0 [Note] InnoDB: 10.4.32 started; log sequence number 334898; transaction id 421
2024-01-25 12:02:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-25 12:02:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-25 12:02:26 0 [ERROR] InnoDB: Page [page id: space=1, page number=3] log sequence number 362281 is in the future! Current system log sequence number 334907.
2024-01-25 12:02:26 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2024-01-25 12:02:26 0 [Note] Server socket created on IP: '::'.
2024-02-01 11:48:27 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 5932
2024-02-01 11:48:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-01 11:48:27 0 [Note] InnoDB: Uses event mutexes
2024-02-01 11:48:27 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-01 11:48:27 0 [Note] InnoDB: Number of pools: 1
2024-02-01 11:48:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-01 11:48:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-01 11:48:27 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-01 11:48:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=367736
2024-02-01 11:48:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-01 11:48:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-02-01 11:48:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-01 11:48:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-01 11:48:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-01 11:48:28 0 [Note] InnoDB: Waiting for purge to start
2024-02-01 11:48:28 0 [Note] InnoDB: 10.4.32 started; log sequence number 367745; transaction id 513
2024-02-01 11:48:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-01 11:48:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-01 11:48:28 0 [Note] InnoDB: Buffer pool(s) load completed at 240201 11:48:28
2024-02-01 11:48:28 0 [Note] Server socket created on IP: '::'.
2024-02-08 11:43:34 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21012
2024-02-08 11:43:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-08 11:43:34 0 [Note] InnoDB: Uses event mutexes
2024-02-08 11:43:34 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-08 11:43:34 0 [Note] InnoDB: Number of pools: 1
2024-02-08 11:43:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-08 11:43:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-08 11:43:34 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-08 11:43:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=404437
2024-02-08 11:43:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-08 11:43:35 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-02-08 11:43:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-08 11:43:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-08 11:43:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-08 11:43:35 0 [Note] InnoDB: Waiting for purge to start
2024-02-08 11:43:35 0 [Note] InnoDB: 10.4.32 started; log sequence number 404446; transaction id 649
2024-02-08 11:43:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-08 11:43:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-08 11:43:35 0 [Note] InnoDB: Buffer pool(s) load completed at 240208 11:43:35
2024-02-08 11:43:35 0 [Note] Server socket created on IP: '::'.
2024-02-17 10:49:32 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 11208
2024-02-17 10:49:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 10:49:32 0 [Note] InnoDB: Uses event mutexes
2024-02-17 10:49:32 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 10:49:32 0 [Note] InnoDB: Number of pools: 1
2024-02-17 10:49:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 10:49:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 10:49:32 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 10:49:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=404455
2024-02-17 10:49:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 10:49:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-02-17 10:49:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 10:49:32 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 10:49:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 10:49:32 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 10:49:32 0 [Note] InnoDB: 10.4.32 started; log sequence number 404464; transaction id 649
2024-02-17 10:49:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 10:49:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 10:49:32 0 [Note] InnoDB: Buffer pool(s) load completed at 240217 10:49:32
2024-02-17 10:49:32 0 [Note] Server socket created on IP: '::'.
2024-02-17 10:54:10 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 1224
2024-02-17 10:54:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 10:54:10 0 [Note] InnoDB: Uses event mutexes
2024-02-17 10:54:10 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 10:54:10 0 [Note] InnoDB: Number of pools: 1
2024-02-17 10:54:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 10:54:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 10:54:10 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 10:54:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=404473
2024-02-17 10:54:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 10:54:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-02-17 10:54:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 10:54:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 10:54:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 10:54:10 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 10:54:10 0 [Note] InnoDB: 10.4.32 started; log sequence number 404498; transaction id 649
2024-02-17 10:54:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 10:54:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 10:54:10 0 [Note] Server socket created on IP: '::'.
2024-02-17 10:54:47 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 17644
2024-02-17 10:54:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 10:54:47 0 [Note] InnoDB: Uses event mutexes
2024-02-17 10:54:47 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 10:54:47 0 [Note] InnoDB: Number of pools: 1
2024-02-17 10:54:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 10:54:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 10:54:47 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 10:54:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 10:54:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 10:54:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 10:54:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 10:54:47 0 [Note] InnoDB: 10.4.32 started; log sequence number 404507; transaction id 649
2024-02-17 10:54:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 10:54:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 10:54:47 0 [Note] Server socket created on IP: '::'.
2024-02-17 10:55:21 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21580
2024-02-17 10:55:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 10:55:21 0 [Note] InnoDB: Uses event mutexes
2024-02-17 10:55:21 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 10:55:21 0 [Note] InnoDB: Number of pools: 1
2024-02-17 10:55:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 10:55:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 10:55:21 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 10:55:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 10:55:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 10:55:21 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 10:55:21 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 10:55:21 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 10:55:21 0 [Note] InnoDB: 10.4.32 started; log sequence number 404516; transaction id 649
2024-02-17 10:55:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 10:55:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 10:55:21 0 [Note] Server socket created on IP: '::'.
2024-02-17 10:56:10 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 18300
2024-02-17 10:56:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 10:56:10 0 [Note] InnoDB: Uses event mutexes
2024-02-17 10:56:10 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 10:56:10 0 [Note] InnoDB: Number of pools: 1
2024-02-17 10:56:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 10:56:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 10:56:10 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 10:56:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 10:56:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 10:56:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 10:56:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 10:56:10 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 10:56:10 0 [Note] InnoDB: 10.4.32 started; log sequence number 404525; transaction id 649
2024-02-17 10:56:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 10:56:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 10:56:10 0 [Note] Server socket created on IP: '::'.
2024-02-17 10:58:44 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 23992
2024-02-17 10:58:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 10:58:44 0 [Note] InnoDB: Uses event mutexes
2024-02-17 10:58:44 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 10:58:44 0 [Note] InnoDB: Number of pools: 1
2024-02-17 10:58:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 10:58:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 10:58:44 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 10:58:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 10:58:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 10:58:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 10:58:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 10:58:44 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 10:58:44 0 [Note] InnoDB: 10.4.32 started; log sequence number 404534; transaction id 649
2024-02-17 10:58:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 10:58:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 10:58:44 0 [Note] Server socket created on IP: '::'.
2024-02-17 10:58:47 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 17356
2024-02-17 10:58:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 10:58:47 0 [Note] InnoDB: Uses event mutexes
2024-02-17 10:58:47 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 10:58:47 0 [Note] InnoDB: Number of pools: 1
2024-02-17 10:58:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 10:58:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 10:58:47 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 10:58:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 10:58:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 10:58:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 10:58:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 10:58:47 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 10:58:47 0 [Note] InnoDB: 10.4.32 started; log sequence number 404543; transaction id 649
2024-02-17 10:58:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 10:58:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 10:58:47 0 [Note] Server socket created on IP: '::'.
2024-02-17 11:01:41 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21640
2024-02-17 11:01:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 11:01:41 0 [Note] InnoDB: Uses event mutexes
2024-02-17 11:01:41 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 11:01:41 0 [Note] InnoDB: Number of pools: 1
2024-02-17 11:01:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 11:01:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 11:01:41 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 11:01:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 11:01:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 11:01:41 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 11:01:41 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 11:01:41 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 11:01:42 0 [Note] InnoDB: 10.4.32 started; log sequence number 404552; transaction id 649
2024-02-17 11:01:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 11:01:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 11:01:42 0 [Note] Server socket created on IP: '::'.
2024-02-17 11:04:04 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 18212
2024-02-17 11:04:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 11:04:04 0 [Note] InnoDB: Uses event mutexes
2024-02-17 11:04:04 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 11:04:04 0 [Note] InnoDB: Number of pools: 1
2024-02-17 11:04:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 11:04:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 11:04:04 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 11:04:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 11:04:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 11:04:04 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 11:04:04 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 11:04:04 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 11:04:04 0 [Note] InnoDB: 10.4.32 started; log sequence number 404561; transaction id 649
2024-02-17 11:04:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 11:04:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 11:04:04 0 [Note] Server socket created on IP: '::'.
2024-02-17 11:04:59 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 12436
2024-02-17 11:04:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 11:04:59 0 [Note] InnoDB: Uses event mutexes
2024-02-17 11:04:59 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 11:04:59 0 [Note] InnoDB: Number of pools: 1
2024-02-17 11:04:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 11:04:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 11:04:59 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 11:05:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 11:05:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 11:05:00 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 11:05:00 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 11:05:00 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 11:05:00 0 [Note] InnoDB: 10.4.32 started; log sequence number 404570; transaction id 649
2024-02-17 11:05:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 11:05:00 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 11:05:00 0 [Note] Server socket created on IP: '::'.
2024-02-17 11:16:08 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 15372
2024-02-17 11:16:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 11:16:08 0 [Note] InnoDB: Uses event mutexes
2024-02-17 11:16:08 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 11:16:08 0 [Note] InnoDB: Number of pools: 1
2024-02-17 11:16:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 11:16:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 11:16:08 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 11:16:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 11:16:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 11:16:08 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 11:16:08 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 11:16:08 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 11:16:08 0 [Note] InnoDB: 10.4.32 started; log sequence number 404579; transaction id 649
2024-02-17 11:16:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 11:16:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 11:16:08 0 [Note] Server socket created on IP: '::'.
2024-02-17 11:16:17 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21828
2024-02-17 11:16:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 11:16:17 0 [Note] InnoDB: Uses event mutexes
2024-02-17 11:16:17 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 11:16:17 0 [Note] InnoDB: Number of pools: 1
2024-02-17 11:16:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 11:16:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 11:16:17 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 11:16:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 11:16:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 11:16:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 11:16:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 11:16:17 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 11:16:17 0 [Note] InnoDB: 10.4.32 started; log sequence number 404588; transaction id 649
2024-02-17 11:16:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 11:16:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 11:16:17 0 [Note] Server socket created on IP: '::'.
2024-02-17 11:16:20 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 24764
2024-02-17 11:16:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 11:16:20 0 [Note] InnoDB: Uses event mutexes
2024-02-17 11:16:20 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 11:16:20 0 [Note] InnoDB: Number of pools: 1
2024-02-17 11:16:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 11:16:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 11:16:20 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 11:16:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 11:16:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-02-17 11:16:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 11:16:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 11:16:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 11:16:20 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 11:16:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 404588; transaction id 649
2024-02-17 11:16:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 11:16:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 11:16:20 0 [Note] Server socket created on IP: '::'.
2024-02-17 11:16:43 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 20712
2024-02-17 11:16:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-17 11:16:43 0 [Note] InnoDB: Uses event mutexes
2024-02-17 11:16:43 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-17 11:16:43 0 [Note] InnoDB: Number of pools: 1
2024-02-17 11:16:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-17 11:16:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-17 11:16:43 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-17 11:16:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-17 11:16:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-17 11:16:43 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-17 11:16:43 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-17 11:16:43 0 [Note] InnoDB: Waiting for purge to start
2024-02-17 11:16:44 0 [Note] InnoDB: 10.4.32 started; log sequence number 404597; transaction id 649
2024-02-17 11:16:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-17 11:16:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-02-17 11:16:44 0 [Note] Server socket created on IP: '::'.


[MilesWeb]

There may require further investigation, about MySQL crashed. You can follow some of below mentioned tricks you can try out,
1. Can you access the command line and know the MySQL root user credentials?? try using mysqldump command to create backup of your data.
2. check what are MySQL error logs, which can be found in /var/log/mysql command
3. with top or htop command, check if MySQL is consuming excessive resources
4. checkout if MySQL configuration files (my.cnf) are free of syntax errors
5. try myisamchk command to repair MyISAM tables

[intspeed]

I have exactly the same problem. I had installed xampp and put in two websites and they are working. 2 days after (not used in between) MySQL won't start anymore. I will enclose a log from mysql. The first part is to my opinion a healthy start on the 25th of feb and the part of the 28th gives result of starting. I also get a memory access error when I want to close and quit xampp.

Mysql log
2024-02-25 9:18:12 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 27064
2024-02-25 9:18:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-25 9:18:12 0 [Note] InnoDB: Uses event mutexes
2024-02-25 9:18:12 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-25 9:18:12 0 [Note] InnoDB: Number of pools: 1
2024-02-25 9:18:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-25 9:18:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-25 9:18:12 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-25 9:18:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-02-25 9:18:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-25 9:18:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-02-25 9:18:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-25 9:18:12 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-25 9:18:12 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-25 9:18:12 0 [Note] InnoDB: Waiting for purge to start
2024-02-25 9:18:12 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-02-25 9:18:12 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2024-02-25 9:18:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-25 9:18:12 0 [Note] InnoDB: Buffer pool(s) load completed at 240225 9:18:12
2024-02-25 9:18:12 0 [Note] Server socket created on IP: '::'.
2024-02-28 18:11:37 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 9272
2024-02-28 18:11:37 0 [ERROR] mysqld.exe: Aria engine: log data error
last_log_page: (1,0x4000) is less than
checkpoint page: (1,0x6000)
2024-02-28 18:11:37 0 [ERROR] mysqld.exe: Aria engine: log initialization failed
2024-02-28 18:11:37 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-28 18:11:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-28 18:11:37 0 [Note] InnoDB: Uses event mutexes
2024-02-28 18:11:37 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-28 18:11:37 0 [Note] InnoDB: Number of pools: 1
2024-02-28 18:11:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-28 18:11:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-28 18:11:37 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-28 18:11:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=21717562
2024-02-28 18:11:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-28 18:11:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-02-28 18:11:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-28 18:11:38 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-28 18:11:38 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-28 18:11:38 0 [Note] InnoDB: Waiting for purge to start
2024-02-28 18:11:38 0 [Note] InnoDB: 10.4.32 started; log sequence number 21717571; transaction id 10772
2024-02-28 18:11:38 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2024-02-28 18:11:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-28 18:11:38 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-02-28 18:11:38 0 [ERROR] Failed to initialize plugins.
2024-02-28 18:11:38 0 [ERROR] Aborting
2024-02-28 18:12:14 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 25308
2024-02-28 18:12:14 0 [ERROR] mysqld.exe: Aria engine: log data error
last_log_page: (1,0x4000) is less than
checkpoint page: (1,0x6000)
2024-02-28 18:12:14 0 [ERROR] mysqld.exe: Aria engine: log initialization failed
2024-02-28 18:12:14 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-28 18:12:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-28 18:12:14 0 [Note] InnoDB: Uses event mutexes
2024-02-28 18:12:14 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-28 18:12:14 0 [Note] InnoDB: Number of pools: 1
2024-02-28 18:12:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-28 18:12:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-28 18:12:14 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-28 18:12:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-28 18:12:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-28 18:12:14 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-28 18:12:14 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-28 18:12:14 0 [Note] InnoDB: Waiting for purge to start
2024-02-28 18:12:14 0 [Note] InnoDB: 10.4.32 started; log sequence number 21717580; transaction id 10772
2024-02-28 18:12:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-28 18:12:14 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2024-02-28 18:12:14 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-02-28 18:12:14 0 [ERROR] Failed to initialize plugins.
2024-02-28 18:12:14 0 [ERROR] Aborting
2024-02-28 18:12:48 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 23320
2024-02-28 18:12:48 0 [ERROR] mysqld.exe: Aria engine: log data error
last_log_page: (1,0x4000) is less than
checkpoint page: (1,0x6000)
2024-02-28 18:12:48 0 [ERROR] mysqld.exe: Aria engine: log initialization failed
2024-02-28 18:12:48 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-28 18:12:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-28 18:12:48 0 [Note] InnoDB: Uses event mutexes
2024-02-28 18:12:48 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-28 18:12:48 0 [Note] InnoDB: Number of pools: 1
2024-02-28 18:12:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-28 18:12:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-28 18:12:48 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-28 18:12:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-28 18:12:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-28 18:12:49 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-28 18:12:49 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-28 18:12:49 0 [Note] InnoDB: Waiting for purge to start
2024-02-28 18:12:49 0 [Note] InnoDB: 10.4.32 started; log sequence number 21717589; transaction id 10772
2024-02-28 18:12:49 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2024-02-28 18:12:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-28 18:12:49 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-02-28 18:12:49 0 [ERROR] Failed to initialize plugins.
2024-02-28 18:12:49 0 [ERROR] Aborting

In windows log I see the error: "Plugin 'Aria' registration as a STORAGE ENGINE failed."
I am using Windows 11 pro 24H2 build 26058.1300 and no problems with any other program....

In despite I have a very little knowledge of internals of mysql.

I have never met before such behaviour of xampp and use it for many years by some priods.

Thanks a lot for helping

[sarefo]

did you update windows 11 before that? I had a working install, and after I updated windows, I got weird errors, similar to yours. nobody here seems to have any idea about it though

[Ismail23]

Hi,
I got the exact same issue, could you solve it?
My Error Log:
2024-03-06 8:29:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-06 8:29:09 0 [Note] InnoDB: Uses event mutexes
2024-03-06 8:29:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-03-06 8:29:09 0 [Note] InnoDB: Number of pools: 1
2024-03-06 8:29:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-06 8:29:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-06 8:29:09 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-06 8:29:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-06 8:29:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-06 8:29:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-06 8:29:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-06 8:29:09 0 [Note] InnoDB: 10.4.22 started; log sequence number 199162386978; transaction id 316886
2024-03-06 8:29:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-06 8:29:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-06 8:29:09 0 [Note] Server socket created on IP: '::'.