Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby tonystar83 » 13. May 2020 11:58

Hi,
yesterday i closed pc after a day of job and xampp and mysql they worked properly,
Today, i i turned on the pc, i started xampp and apache and everything ok but when i started mysql not start and i see this error:

12:46:55 [mysql] Error: MySQL shutdown unexpectedly.
12:46:55 [mysql] This may be due to a blocked port, missing dependencies,
12:46:55 [mysql] improper privileges, a crash, or a shutdown by another method.
12:46:55 [mysql] Press the Logs button to view error logs and check
12:46:55 [mysql] the Windows Event Viewer for more clues
12:46:55 [mysql] If you need more help, copy and post this
12:46:55 [mysql] entire log window on the forums

In log file there is this:
InnoDB: using atomic writes.
2020-05-13 11:46:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-05-13 11:46:45 0 [Note] InnoDB: Uses event mutexes
2020-05-13 11:46:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-13 11:46:45 0 [Note] InnoDB: Number of pools: 1
2020-05-13 11:46:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-05-13 11:46:45 0 [Note] InnoDB: Disabling background log and ibuf IO write threads.
2020-05-13 11:46:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-05-13 11:46:45 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-13 11:46:45 0 [Note] InnoDB: innodb_force_recovery=6 skips redo log apply
2020-05-13 11:46:45 0 [Note] InnoDB: 10.4.11 started; log sequence number 0; transaction id 0
2020-05-13 11:46:45 0 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!!
2020-05-13 11:46:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-13 11:46:45 0 [Note] Server socket created on IP: '::'.

I replaced the file in the mysql / data / folder with the backup files and everything went well again. However, when I replace the folder C: \ xampp \ mysql \ data \ mysql it no longer works.
I did some testing replacing the files present in the folder C: \ xampp \ mysql \ data and I realize that replacing them all except the mysql folder, xampp restarts but in phpmyadmin it returns the error # 1932 - Table 'phpmyadmin.pma__tracking 'doesn't exist in engine. However, if I also replace the mysql folder it no longer starts

Help Me
tonystar83
 
Posts: 1
Joined: 13. May 2020 11:48
XAMPP version: 3.2.4
Operating System: Windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 71 guests