MySQL stops

[rf1234]

I can't get MySQL started any longer. It stops with this error message. Please help. Many thanks.

07:09:29 [mysql] Statusänderung erkannt: gestoppt
07:09:29 [mysql] Fehler: MySQL wurde unerwartet beendet
07:09:29 [mysql] Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
07:09:29 [mysql] fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
07:09:29 [mysql] Drücke den Logs Button um error logs zu sehen und prüfe
07:09:29 [mysql] im Windows Event Viewer für weitere Hinweise
07:09:29 [mysql] Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
07:09:29 [mysql] und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.

And this is the error log:

InnoDB: using atomic writes.
2022-05-20 7:09:27 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2022-05-20 7:09:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-05-20 7:09:27 0 [Note] InnoDB: Uses event mutexes
2022-05-20 7:09:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-20 7:09:27 0 [Note] InnoDB: Number of pools: 1
2022-05-20 7:09:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-05-20 7:09:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-05-20 7:09:27 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-20 7:09:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2022-05-20 7:09:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
2022-05-20 7:09:27 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2022-05-20 7:09:27 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2022-05-20 7:09:27 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2022-05-20 7:09:27 0 [Note] InnoDB: New log files created, LSN=11451
2022-05-20 7:09:27 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2022-05-20 7:09:27 0 [Note] InnoDB: Doublewrite buffer created
2022-05-20 7:09:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-05-20 7:09:27 0 [Note] InnoDB: Creating foreign key constraint system tables.
2022-05-20 7:09:27 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2022-05-20 7:09:27 0 [Note] InnoDB: Creating sys_virtual system tables.
2022-05-20 7:09:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-20 7:09:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-20 7:09:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-05-20 7:09:27 0 [Note] InnoDB: Waiting for purge to start
2022-05-20 7:09:27 0 [Note] InnoDB: 10.4.17 started; log sequence number 0; transaction id 7
2022-05-20 7:09:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-20 7:09:27 0 [Note] Zerofilling moved table: '.\mysql\plugin'
2022-05-20 7:09:27 0 [Note] Zerofilling moved table: '.\mysql\servers'
2022-05-20 7:09:27 0 [Note] Server socket created on IP: '::'.

[Altrea]

Hi,

Try to start MariaDB as console application and tell us what it responses. To do so, please:

• Open a new XAMPP Shell by clicking the Shell Button in your control panel
• type in the following command
  

  Code: Select all

  mysqld --defaults-file=mysql\bin\my.ini --standalone --console

• copy us the response of the console

[rf1234]

Here you are. Thanks for helping!

mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2022-05-23 10:13:14 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.
2022-05-23 10:13:14 0 [Note] mysqld (mysqld 10.4.17-MariaDB) starting as process 17980 ...
InnoDB: using atomic writes.
2022-05-23 10:13:14 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-05-23 10:13:14 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-05-23 10:13:14 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-05-23 10:13:14 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-05-23 10:13:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-23 10:13:14 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-05-23 10:13:14 0 [ERROR] Aborting

[Altrea]

2022-05-23 10:13:14 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable

This message often occurs if MariaDB is already started

[rf1234]

You are right. Maria DB had already been started. But it is still not working: Since the crash I get a database connection error which hadn't been there before. And I don't have it in my live system either.

I entered your command again after stopping Maria DB. Maybe the response is more helpful for you now.

# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2022-05-24 11:50:52 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.
2022-05-24 11:50:52 0 [Note] mysqld (mysqld 10.4.17-MariaDB) starting as process 2376 ...
InnoDB: using atomic writes.
2022-05-24 11:50:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-05-24 11:50:52 0 [Note] InnoDB: Uses event mutexes
2022-05-24 11:50:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-24 11:50:52 0 [Note] InnoDB: Number of pools: 1
2022-05-24 11:50:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-05-24 11:50:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-05-24 11:50:52 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-24 11:50:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=141277
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=136, page number=2] with future log sequence number 487402904
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1071] with future log sequence number 487549839
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=286] with future log sequence number 495731927
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=943] with future log sequence number 495731927
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=285] with future log sequence number 495731883
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=906] with future log sequence number 495731883
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=282] with future log sequence number 495731839
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1078] with future log sequence number 495731839
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=281] with future log sequence number 495731795
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=331] with future log sequence number 495731795
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=280] with future log sequence number 495731751
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=330] with future log sequence number 495731751
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=279] with future log sequence number 495731691
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=329] with future log sequence number 495731691
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=277] with future log sequence number 495731647
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1077] with future log sequence number 495731647
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=276] with future log sequence number 495731603
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=327] with future log sequence number 495731603
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=275] with future log sequence number 495731559
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=326] with future log sequence number 495731559
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=274] with future log sequence number 495731515
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=325] with future log sequence number 495731515
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=271] with future log sequence number 495731471
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1070] with future log sequence number 495731471
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=270] with future log sequence number 495731427
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=901] with future log sequence number 495731427
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=269] with future log sequence number 495731383
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=942] with future log sequence number 495731383
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=268] with future log sequence number 495731339
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=941] with future log sequence number 495731339
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=266] with future log sequence number 495731295
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=324] with future log sequence number 495731295
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=265] with future log sequence number 495731251
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1064] with future log sequence number 495731251
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=264] with future log sequence number 495731191
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=323] with future log sequence number 495731191
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=263] with future log sequence number 495731147
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=900] with future log sequence number 495731147
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=261] with future log sequence number 495731103
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=320] with future log sequence number 495731103
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=260] with future log sequence number 495731059
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1087] with future log sequence number 495731059
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=259] with future log sequence number 495731015
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1086] with future log sequence number 495731015
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=258] with future log sequence number 495730971
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1085] with future log sequence number 495730971
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=256] with future log sequence number 495730927
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1084] with future log sequence number 495730927
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=255] with future log sequence number 495730883
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1061] with future log sequence number 495730883
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=254] with future log sequence number 495730839
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1083] with future log sequence number 495730839
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=253] with future log sequence number 495730795
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1072] with future log sequence number 495730795
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=252] with future log sequence number 495730751
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=898] with future log sequence number 495730751
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=251] with future log sequence number 495730707
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=897] with future log sequence number 495730707
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=249] with future log sequence number 495730647
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1069] with future log sequence number 495730647
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=248] with future log sequence number 495730603
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1068] with future log sequence number 495730603
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=247] with future log sequence number 495730559
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=896] with future log sequence number 495730559
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=246] with future log sequence number 495730515
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1067] with future log sequence number 495730515
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=244] with future log sequence number 495730471
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=934] with future log sequence number 495730471
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=242] with future log sequence number 495730427
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1058] with future log sequence number 495730427
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=241] with future log sequence number 495730383
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=933] with future log sequence number 495730383
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=240] with future log sequence number 495730339
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1057] with future log sequence number 495730339
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=239] with future log sequence number 495730295
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1046] with future log sequence number 495730295
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=238] with future log sequence number 495730251
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=1045] with future log sequence number 495730251
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=236] with future log sequence number 495729524
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=912] with future log sequence number 495729524
2022-05-24 11:50:52 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=322] with future log sequence number 495730251
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=7] log sequence number 495719698 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=3] log sequence number 341467173 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=2] log sequence number 492271661 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=4] log sequence number 491831728 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=11] log sequence number 385228232 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=1047] log sequence number 385228232 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=1] log sequence number 341467173 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=6] log sequence number 493353934 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=45] log sequence number 493354051 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=46] log sequence number 493354090 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=1082] log sequence number 493354090 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=47] log sequence number 493354129 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=347] log sequence number 493354129 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=48] log sequence number 493354168 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=348] log sequence number 493354168 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=49] log sequence number 487426155 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=383] log sequence number 487426155 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=50] log sequence number 487426194 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=349] log sequence number 487426194 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=51] log sequence number 487426233 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=474] log sequence number 487426233 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=52] log sequence number 431022990 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=350] log sequence number 431022990 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=53] log sequence number 487426432 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=54] log sequence number 487426471 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=351] log sequence number 487426471 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=55] log sequence number 487426527 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=352] log sequence number 487426527 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=56] log sequence number 487426582 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=353] log sequence number 487426582 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=57] log sequence number 487426688 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=384] log sequence number 487426688 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=58] log sequence number 487426727 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=354] log sequence number 487426727 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=59] log sequence number 431023201 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=355] log sequence number 431023201 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=60] log sequence number 487428004 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=356] log sequence number 487428004 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=61] log sequence number 487428658 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=385] log sequence number 487428658 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=62] log sequence number 487429241 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=357] log sequence number 487429241 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=63] log sequence number 487429512 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=358] log sequence number 487429512 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=192] log sequence number 487430096 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=359] log sequence number 487430096 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=193] log sequence number 493357522 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=194] log sequence number 493358096 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=195] log sequence number 493358140 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=923] log sequence number 493358140 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=196] log sequence number 493358184 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=362] log sequence number 493358184 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Page [page id: space=0, page number=197] log sequence number 493358228 is in the future! Current system log sequence number 141295.
2022-05-24 11:50:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
.... abbreviated rf1234
2022-05-24 11:50:52 0 [Note] Reading of all Master_info entries succeeded
2022-05-24 11:50:52 0 [Note] Added new Master_info '' to hash table
2022-05-24 11:50:52 0 [Note] mysqld: ready for connections.
Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

[rf1234]

Ok, I deleted those log files and all other files in ...\xampp\mysql\data

Then I recovered just the file ibdata1. Then I could access my db using mysql Workbench but I still couldn't log in.

Using PHPmyadmin I noticed that my application user id had gone. So I added the user again - and now it works!

Problem solved! Thanks.