I use my XAMPP for apache and mysql, to get the localhost and import database so I can work on the sites frontend.

I have a recurring problem, where my XAMPP (Version 8.2.12) mySQL (Ver 15.1 Distrib 10.4.32-MariaDB, for Win64 (AMD64), source revision c4143f909528e3fab0677a28631d10389354c491) stops working, usually when I shut it down and try to start it again but it fails. Now this has been keep happening for every month(i’m guessing it’s the size of databases or some ibdata, ibtmp they generate) so, where I either shut it down and can’t start or myPhpAdmin is not working and restarting fails. This I fixed usually by copying backup contents in xampp/mysql to /data, there were various solutions I tried found on stackoverflow but ultimately it still keeps happening and I’m unable keep the databases, so I need to import them again.

I dont know if it’s related but when I was on Windows 10 everything worked fine for years once I clean installed Win11 this recurring problem started another thing could be the newer XAMPP(and it’s modules) version.

mysql_error.log

2024-05-23 23:33:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-05-23 23:33:11 0 [Note] InnoDB: Uses event mutexes
2024-05-23 23:33:11 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-05-23 23:33:11 0 [Note] InnoDB: Number of pools: 1
2024-05-23 23:33:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-23 23:33:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-05-23 23:33:11 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-23 23:33:11 0 [Note] InnoDB: The log sequence number 526409885 in the system tablespace does not match the log sequence number 1075268620 in the ib_logfiles!
2024-05-23 23:33:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-23 23:33:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-23 23:33:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-23 23:33:11 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-23 23:33:11 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2024-05-23 23:33:11 0 [Note] InnoDB: Waiting for purge to start
2024-05-23 23:33:11 0 [Note] InnoDB: 10.4.32 started; log sequence number 1075268620; transaction id 1068489
2024-05-23 23:33:11 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2024-05-23 23:33:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-23 23:33:11 0 [Note] InnoDB: Buffer pool(s) load completed at 240523 23:33:11
2024-05-23 23:33:11 0 [Note] Server socket created on IP: '::'.

I also tried changing mysql.ini to no success, tried increasing sizes, adding variations of this, which made mysql unable start at all or fail later:

innodb_temp_data_file_path=ibtmp1:50M:autoextend:max:500M

Any help appreciated!