M
M
Maxim Vakaev2020-04-03 18:14:52
MySQL
Maxim Vakaev, 2020-04-03 18:14:52

MySQL does not start in xampp, what should I do?

For some reason, mySQL stopped working, today everything was running fine, maybe someone came across? what can be done?

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


InnoDB: using atomic writes.
2020-04-03 17:41:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-03 17:41:35 0 [Note] InnoDB: Uses event mutexes
2020-04-03 17:41:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-03 17:41:35 0 [Note] InnoDB: Number of pools: 1
2020-04-03 17:41:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-03 17:41:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-03 17:41:35 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-03 17:41:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-03 17:41:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-03 17:41:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-03 17:41:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-03 17:41:35 0 [Note] InnoDB: 10.4.11 started; log sequence number 10282705; transaction id 18356
2020-04-03 17:41:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-03 17:41:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-03 17:41:35 0 [Note] Server socket created on IP: '::'.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
T
ThunderCat, 2020-04-03
@dev_max

Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait...
check that it is not full, put more ...
Check what port is busy on which the muscle is hung
Check if there is a pid file in the folder - it must be deleted.

W
Werby, 2021-03-02
@Werby

C:\xampp\mysql - there is a back up folder in this folder
The contents of the back up folder must be copied to the data folder, in the default path: C:\xampp\mysql\data I
also recommend viewing: https://www.youtube .com/watch?v=D9JAT-kUDAE - there is another way to solve it, which did not help me, but, nevertheless.
I also solved the problem by reinstalling, but every time you rearrange after turning on the computer - you get tired

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question