Error: MySQL shutdown unexpectedly

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error: MySQL shutdown unexpectedly

Postby anjanesh » 14. November 2023 04:26

Same issue, I went out of town for 3 days and all of a sudden my MySQL isn't starting.

Code: Select all
2023-11-14  8:53:07 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 1060
2023-11-14  8:53:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-14  8:53:07 0 [Note] InnoDB: Uses event mutexes
2023-11-14  8:53:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-14  8:53:07 0 [Note] InnoDB: Number of pools: 1
2023-11-14  8:53:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-14  8:53:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-14  8:53:07 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-14  8:53:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-14  8:53:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-14  8:53:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-14  8:53:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-14  8:53:07 0 [Note] InnoDB: Waiting for purge to start
2023-11-14  8:53:07 0 [Note] InnoDB: 10.4.28 started; log sequence number 2498409547; transaction id 18646
2023-11-14  8:53:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-14  8:53:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-14  8:53:07 0 [Note] Server socket created on IP: '127.0.0.1'.


Code: Select all
PS C:\xampp\mysql\data> ls


    Directory: C:\xampp\mysql\data


Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d-----        14-11-2023     08:06                mysql
d-----        11-05-2023     20:57                performance_schema
d-----        11-05-2023     20:57                phpmyadmin
d-----        11-05-2023     20:57                test
-a----        14-11-2023     08:53          24576 aria_log.00000001
-a----        14-11-2023     08:41             52 aria_log_control
-a----        14-11-2023     08:53       79691776 ibdata1
-a----        14-11-2023     08:41           2074 ib_buffer_pool
-a----        14-11-2023     08:53        5242880 ib_logfile0
-a----        14-11-2023     08:42        5242880 ib_logfile1
-a----        21-10-2019     17:47             49 my.ini
-a----        25-07-2023     05:27         146423 mysqld.dmp
-a----        14-11-2023     08:53           1487 mysql_error.log
-a----        14-11-2023     08:41           6277 ZERO_BOOK_ULTRA.err


I don't have these files :
Code: Select all
Delete the file "multi-master.info"
Delete all files beginning with "master-"
Delete all files beginning with "mysql_relay-bin-"
Delete all files beginning with "relay-log-"
anjanesh
 
Posts: 3
Joined: 22. September 2023 05:00
XAMPP version: 3.3.0
Operating System: Windows 11

Re: Error: MySQL shutdown unexpectedly

Postby Altrea » 14. November 2023 08:56

Then it is/was not the same issue, obviously.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 184 guests