MySQL shutdown

[Lisa67]

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

InnoDB: using atomic writes.
2019-12-06 8:54:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-06 8:54:16 0 [Note] InnoDB: Uses event mutexes
2019-12-06 8:54:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-06 8:54:16 0 [Note] InnoDB: Number of pools: 1
2019-12-06 8:54:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-06 8:54:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-12-06 8:54:16 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-06 8:54:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-06 8:54:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-06 8:54:17 0 [Note] InnoDB: Setting file 'D:\XAMPP\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-06 8:54:17 0 [Note] InnoDB: File 'D:\XAMPP\mysql\data\ibtmp1' size is now 12 MB.
2019-12-06 8:54:17 0 [Note] InnoDB: Waiting for purge to start
2019-12-06 8:54:17 0 [Note] InnoDB: 10.4.8 started; log sequence number 113872; transaction id 9
2019-12-06 8:54:17 0 [Note] InnoDB: Loading buffer pool(s) from D:\XAMPP\mysql\data\ib_buffer_pool
2019-12-06 8:54:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-06 8:54:17 0 [Note] InnoDB: Buffer pool(s) load completed at 191206 8:54:17
2019-12-06 8:54:17 0 [Note] Server socket created on IP: '::'.

can you help me this is the second time I have this problem. What can I do ?
Lisa

[Altrea]

Hi,

There is no specific error message in your log file.
Can you try to start mariadb as console?

• open your xampp control panel
• click the Shell Button
• in the shell type in this command
  

  Code: Select all

  mysqld --console

The console should bring you some up to date log messages

[Lisa67]

Hi and thanks,
I do what you say and I have this message
2019-12-06 18:58 Note using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-12-06 18:58:19 Note MYSQLD (mysqld 10.4.8-MariaDB) starting as process 10772...
I change in config my.ini

but I have the same problem
next message 2019-12-06 19:05:18 0 Note MYSQLD (mysqld 10.4.8-MariaDB) starting as process 8028...

What can I do ?
Thanks for your help
Sorry for my Englis I'm French
Lisa

[Nobbie]

Sorry for my Englis I'm French

Go to www.deepl.com and translate everything. That translator is very sophisticated and will help you in any case.

[Altrea]

I don't see any issue here. Seems like MariaDB can start successfully.

Which changes did you make in your my.ini?

[Lisa67]

I reinstalled XAMPP and here are the messages

2019-12-06 21:03:44 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-12-06 21:03:44 0 [Note] mysqld (mysqld 10.4.8-MariaDB) starting as process 11320 ...
InnoDB: using atomic writes.
2019-12-06 21:03:44 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-12-06 21:03:44 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-12-06 21:03:44 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-06 21:03:44 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-06 21:03:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-06 21:03:44 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-12-06 21:03:44 0 [ERROR] Aborting

I do the change in config my.ini

[Altrea]

Where did you install xampp?

[Lisa67]

on my disk D: \\ XAMPP and not in the C system to be able to do my backups