XAMPP startet MySQL nicht mehr

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

XAMPP startet MySQL nicht mehr

Postby musicmaster » 01. February 2022 21:29

After my last Windows update Mysql refused to start. Or more correctly: it started bu closed down after 5 minutes.

12:24:56 [mysql] Attempting to start MySQL app...
12:24:56 [mysql] Status change detected: running
12:29:31 [mysql] Status change detected: stopped
12:29:31 [mysql] Error: MySQL shutdown unexpectedly.
12:29:31 [mysql] This may be due to a blocked port, missing dependencies,
12:29:31 [mysql] improper privileges, a crash, or a shutdown by another method.
12:29:31 [mysql] Press the Logs button to view error logs and check
12:29:31 [mysql] the Windows Event Viewer for more clues
12:29:31 [mysql] If you need more help, copy and post this
12:29:31 [mysql] entire log window on the forums


Looking in the log file I saw the following:

2022-02-01 12:24:57 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-02-01 12:24:57 0 [ERROR] Plugin 'Aria' init function returned error.
2022-02-01 12:24:57 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2022-02-01 12:24:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-01 12:24:57 0 [Note] InnoDB: Uses event mutexes
2022-02-01 12:24:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-01 12:24:57 0 [Note] InnoDB: Number of pools: 1
2022-02-01 12:24:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-01 12:24:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-01 12:24:58 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-01 12:29:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-01 12:29:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-01 12:29:30 0 [Note] InnoDB: Setting file 'D:\xampp73\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-01 12:29:30 0 [Note] InnoDB: File 'D:\xampp73\mysql\data\ibtmp1' size is now 12 MB.
2022-02-01 12:29:30 0 [Note] InnoDB: Waiting for purge to start
2022-02-01 12:29:30 0 [Note] InnoDB: 10.4.8 started; log sequence number 32030148760; transaction id 7983255
2022-02-01 12:29:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-01 12:29:30 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-02-01 12:29:30 0 [ERROR] Failed to initialize plugins.
2022-02-01 12:29:30 0 [ERROR] Aborting


Following also some advice on Stackoverflow I tried aria_chk both after just deleting the log file and also deleting the log file and aria_log_control.
After some time the aria error disappeared. But Mysql still shuts down after a minute. In the logfile I see now:

InnoDB: using atomic writes.
2022-02-01 21:33:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-01 21:33:33 0 [Note] InnoDB: Uses event mutexes
2022-02-01 21:33:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-01 21:33:33 0 [Note] InnoDB: Number of pools: 1
2022-02-01 21:33:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-01 21:33:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-01 21:33:33 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-01 21:33:34 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*524288000 bytes; LSN=32030149168
2022-02-01 21:33:34 0 [Note] InnoDB: Starting to delete and rewrite log files.
2022-02-01 21:33:34 0 [Note] InnoDB: Setting log file D:\xampp73\mysql\data\ib_logfile101 size to 524288000 bytes
2022-02-01 21:33:34 0 [Note] InnoDB: Setting log file D:\xampp73\mysql\data\ib_logfile1 size to 524288000 bytes
2022-02-01 21:33:34 0 [Note] InnoDB: Renaming log file D:\xampp73\mysql\data\ib_logfile101 to D:\xampp73\mysql\data\ib_logfile0
2022-02-01 21:33:34 0 [Note] InnoDB: New log files created, LSN=32030149168
2022-02-01 21:34:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-01 21:34:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-01 21:34:32 0 [Note] InnoDB: Setting file 'D:\xampp73\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-01 21:34:32 0 [Note] InnoDB: File 'D:\xampp73\mysql\data\ibtmp1' size is now 12 MB.
2022-02-01 21:34:32 0 [Note] InnoDB: Waiting for purge to start
2022-02-01 21:34:33 0 [Note] InnoDB: 10.4.8 started; log sequence number 32030149168; transaction id 7983255
2022-02-01 21:34:33 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp73\mysql\data\ib_buffer_pool
2022-02-01 21:34:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-01 21:34:33 0 [Note] Server socket created on IP: '::'.


I tried to to run mysqld but after a minute or so it brings me back to the command prompt.

In this forum I saw the following command recommended: mysqld --console --skip-grant-tables --skip-external-locking
I tried it but then too I don't enter the Mysql prompt. I get this output:

2022-02-01 21:11:55 0 [Note] D:\xampp73\mysql\bin\mysqld.exe (mysqld 10.4.8-MariaDB) starting as process 24672 ...
InnoDB: using atomic writes.
2022-02-01 21:11:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-01 21:11:55 0 [Note] InnoDB: Uses event mutexes
2022-02-01 21:11:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-01 21:11:55 0 [Note] InnoDB: Number of pools: 1
2022-02-01 21:11:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-01 21:11:55 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-02-01 21:11:55 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-01 21:12:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-01 21:12:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-01 21:12:15 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-01 21:12:15 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2022-02-01 21:12:15 0 [Note] InnoDB: Waiting for purge to start
2022-02-01 21:12:15 0 [Note] InnoDB: 10.4.8 started; log sequence number 32030149150; transaction id 7983255
2022-02-01 21:12:15 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp73\mysql\data\ib_buffer_pool
2022-02-01 21:12:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-01 21:12:15 0 [Note] InnoDB: Buffer pool(s) load completed at 220201 21:12:15
2022-02-01 21:12:15 0 [Note] Server socket created on IP: '::'.
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_leap_second'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_name'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition_type'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition'
2022-02-01 21:12:16 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2022-02-01 21:12:16 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=LAPTOP-JOD2HF4P-relay-bin' to avoid this problem.
2022-02-01 21:12:16 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2022-02-01 21:12:16 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] Reading of all Master_info entries succ' to hash table
2022-02-01 21:12:16 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2022-02-01 21:12:16 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
' to hash table2:16 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] Added new Master_info '' to hash table
2022-02-01 21:12:16 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2022-02-01 21:12:16 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2022-02-01 21:12:16 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready ' to hash table.
2022-02-01 21:12:16 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2022-02-01 21:12:16 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' failed
2022-02-01 21:12:16 7 [Note] Added new Master_info 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binar' to hash table
2022-02-01 21:12:16 0 [Warning] Reading of some Master_info entries failed
2022-02-01 21:12:16 0 [ERROR] Failed to initialize multi master structures
2022-02-01 21:12:16 0 [ERROR] Aborting


What should I do to get out of this?
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows

Strange files in mysql/data directory

Postby musicmaster » 02. February 2022 14:21

In older installations I saw - aside from the database files - only the standard files in the mysql/data directory. That is:
aria_log.00000001
aria_log_control
ibdata1
ib_logfile0
ib_logfile1
multi-master.info
mysql.pid
mysql_error.log


In my latest installation I see all kinds of very long filenames. Does anyone know where they come from and what they do? I see that some line come 45 times: what does that mean? Can they be deleted safely?
Code: Select all
LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001
LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.index
LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001
LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.index
LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001
LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.index
LAPTOP-JOD2HF4P-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001
LAPTOP-JOD2HF4P-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.index
LAPTOP-JOD2HF4P.err
master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info
master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info
master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info
master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info
multi-master.info
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000002
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000003
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000004
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000005
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000006
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000007
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000008
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000009
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000010
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000011
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000012
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000013
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000014
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000015
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000016
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000017
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000018
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000019
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000020
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000021
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000022
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000023
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000024
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000025
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000026
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000027
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000028
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000029
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000030
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000031
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000032
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000033
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000034
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000035
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000036
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000037
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000038
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000039
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000040
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000041
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000042
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000043
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000044
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000045
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.index
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000002
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000003
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000004
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000005
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000006
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000007
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000008
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000009
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000010
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000011
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000012
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000013
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000014
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000015
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000016
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000017
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000018
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000019
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000020
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000021
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000022
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000023
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000024
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000025
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000026
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000027
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000028
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000029
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000030
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000031
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000032
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000033
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000034
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000035
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000036
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000037
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000038
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000039
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000040
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000041
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000042
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000043
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000044
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000045
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.index
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000002
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000003
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000004
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000005
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000006
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000007
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000008
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000009
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000010
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000011
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000012
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000013
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000014
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000015
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000016
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000017
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000018
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000019
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000020
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000021
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000022
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000023
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000024
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000025
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000026
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000027
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000028
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000029
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000030
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000031
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000032
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000033
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000034
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000035
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000036
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000037
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000038
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000039
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000040
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000041
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000042
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000043
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000044
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000045
mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.index
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000002
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000003
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000004
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000005
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000006
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000007
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000008
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000009
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000010
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000011
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000012
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000013
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000014
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000015
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000016
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000017
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000018
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000019
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000020
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000021
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000022
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000023
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000024
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000025
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000026
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000027
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000028
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000029
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000030
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000031
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000032
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000033
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000034
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000035
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000036
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000037
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000038
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000039
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000040
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000041
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000042
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000043
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000044
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000045
mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.index
relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info
relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info
relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info
relay-log-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info


Note that I listed this as code because using the quote option will cut off the last part of the file names.
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows

Re: XAMPP startet MySQL nicht mehr

Postby musicmaster » 02. February 2022 16:00

I decided to delete all the .info and other files in the data directory with a long name.

Now the mysqld command worked. It still got errors but it no longer aborted. These were the messages I got:

starting as process 10640 ...
InnoDB: using atomic writes.
2022-02-02 15:43:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-02 15:43:30 0 [Note] InnoDB: Uses event mutexes
2022-02-02 15:43:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-02 15:43:30 0 [Note] InnoDB: Number of pools: 1
2022-02-02 15:43:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-02 15:43:30 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-02-02 15:43:30 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-02 15:43:32 0 [Note] InnoDB: Resizing redo log from 2*524288000 to 2*50331648 bytes; LSN=32030148823
2022-02-02 15:43:32 0 [Note] InnoDB: Starting to delete and rewrite log files.
2022-02-02 15:43:32 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 50331648 bytes
2022-02-02 15:43:32 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 50331648 bytes
2022-02-02 15:43:32 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2022-02-02 15:43:33 0 [Note] InnoDB: New log files created, LSN=32030148823
2022-02-02 15:43:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-02 15:43:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-02 15:43:34 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-02 15:43:34 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2022-02-02 15:43:34 0 [Note] InnoDB: Waiting for purge to start
2022-02-02 15:43:34 0 [Note] InnoDB: 10.4.8 started; log sequence number 32030148823; transaction id 7983255
2022-02-02 15:43:34 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp73\mysql\data\ib_buffer_pool
2022-02-02 15:43:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-02 15:43:34 0 [Note] InnoDB: Buffer pool(s) load completed at 220202 15:43:34
2022-02-02 15:43:34 0 [Note] Zerofilling moved table: '.\mysql\servers'
2022-02-02 15:43:34 0 [Note] Server socket created on IP: '::'.
2022-02-02 15:43:34 0 [Note] Zerofilling moved table: '.\mysql\time_zone_leap_second'
2022-02-02 15:43:34 0 [Note] Zerofilling moved table: '.\mysql\time_zone_name'
2022-02-02 15:43:34 0 [Note] Zerofilling moved table: '.\mysql\time_zone'
2022-02-02 15:43:34 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition_type'
2022-02-02 15:43:34 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition'
2022-02-02 15:43:35 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2022-02-02 15:43:35 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=LAPTOP-JOD2HF4P-relay-bin' to avoid this problem.
2022-02-02 15:43:35 7 [Note] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2022-02-02 15:43:35 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
2022-02-02 15:43:35 7 [Note] Started replication for '2020-11-03 17:22:24 0 [Note] Reading of all Master_info entries su'ceeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001' position: 4
2022-02-02 15:43:35 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
': Slave I/O thread killed while connecting to master:24 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
2022-02-02 15:43:35 7 [Note] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table3:35 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 hash table
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001' position: 4
2022-02-02 15:43:35 7 [Note] Started replication for '2020-11-03 17:22:24 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2022-02-02 15:43:35 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master2:24 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2022-02-02 15:43:35 7 [Note] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2022-02-02 15:43:35 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready ' to hash table.
2022-02-02 15:43:35 12 [Note] Master '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready for connection': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2022-02-02 15:43:35 12 [ERROR] Master '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready for connectio': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2022-02-02 15:43:35 13 [Note] Master '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready for connection': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\LAPTOP-JOD2HF4P-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
2022-02-02 15:43:35 7 [Note] Started replication for '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: read' for connections.
2022-02-02 15:43:35 12 [Note] Master '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready for connection': Slave I/O thread killed while connecting to master
2022-02-02 15:43:35 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2022-02-02 15:43:35 12 [Note] Master '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready for connection': Slave I/O thread exiting, read up to log 'FIRST', position 4
2022-02-02 15:43:35 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2022-02-02 15:43:35 7 [Note] Added new Master_info 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binar' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4db.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\LAPTOP-JOD2HF4P-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001' position: 4
2022-02-02 15:43:35 7 [Note] Started replication for 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org bin'ry distribution
2022-02-02 15:43:35 14 [ERROR] Master 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2022-02-02 15:43:35 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread killed while connecting to master8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2022-02-02 15:43:35 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4 socket: '' port: 3306 mariadb.org binary distribution
2022-02-02 15:43:35 0 [Note] D:\xampp73\mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2022-02-02 16:01:09 18 [Note] Found 29 of 0 rows when repairing '.\mysql\columns_priv'
2022-02-02 16:01:09 18 [Note] Found 6 of 0 rows when repairing '.\mysql\global_priv'
2022-02-02 16:01:09 18 [Note] Found 40 of 0 rows when repairing '.\mysql\help_category'
2022-02-02 16:01:09 18 [Note] Found 475 of 0 rows when repairing '.\mysql\help_keyword'
2022-02-02 16:01:09 18 [Note] Found 1059 of 0 rows when repairing '.\mysql\help_relation'
2022-02-02 16:01:09 18 [Note] Found 529 of 0 rows when repairing '.\mysql\help_topic'
2022-02-02 16:01:10 18 [Note] Found 1 of 0 rows when repairing '.\mysql\proxies_priv'
2022-02-02 16:02:39 19 [Note] Found 29 of 0 rows when repairing '.\mysql\columns_priv'
2022-02-02 16:02:40 19 [Note] Found 6 of 0 rows when repairing '.\mysql\global_priv'
2022-02-02 16:02:40 19 [Note] Found 40 of 0 rows when repairing '.\mysql\help_category'
2022-02-02 16:02:40 19 [Note] Found 475 of 0 rows when repairing '.\mysql\help_keyword'
2022-02-02 16:02:40 19 [Note] Found 1059 of 0 rows when repairing '.\mysql\help_relation'
2022-02-02 16:02:40 19 [Note] Found 529 of 0 rows when repairing '.\mysql\help_topic'
2022-02-02 16:02:40 19 [Note] Found 1 of 0 rows when repairing '.\mysql\proxies_priv'
2022-02-02 16:03:19 20 [Note] Found 29 of 0 rows when repairing '.\mysql\columns_priv'
2022-02-02 16:03:20 20 [Note] Found 6 of 0 rows when repairing '.\mysql\global_priv'
2022-02-02 16:03:20 20 [Note] Found 40 of 0 rows when repairing '.\mysql\help_category'
2022-02-02 16:03:20 20 [Note] Found 475 of 0 rows when repairing '.\mysql\help_keyword'
2022-02-02 16:03:20 20 [Note] Found 1059 of 0 rows when repairing '.\mysql\help_relation'
2022-02-02 16:03:20 20 [Note] Found 529 of 0 rows when repairing '.\mysql\help_topic'
2022-02-02 16:03:20 20 [Note] Found 1 of 0 rows when repairing '.\mysql\proxies_priv'


Now i could run "mysqlcheck -r --databases mysql --use-frm". However, the result was rather dubious. See below

mysql.column_stats OK
mysql.columns_priv
warning : Number of rows changed from 0 to 29
status : OK
mysql.db
info : Wrong CRC on datapage at 1
info : Wrong CRC on datapage at 2
info : Wrong CRC on datapage at 3
info : Wrong CRC on datapage at 4
info : Wrong CRC on datapage at 5
info : Wrong CRC on datapage at 6
info : Wrong CRC on datapage at 7
info : Wrong CRC on datapage at 8
info : Wrong CRC on datapage at 9
info : Wrong CRC on datapage at 10
info : Wrong CRC on datapage at 11
info : Wrong CRC on datapage at 12
info : Wrong CRC on datapage at 14
info : Wrong CRC on datapage at 15
info : Wrong CRC on datapage at 16
info : Wrong CRC on datapage at 17
info : Wrong CRC on datapage at 18
info : Wrong CRC on datapage at 19
info : Wrong CRC on datapage at 20
info : Wrong CRC on datapage at 21
info : Wrong CRC on datapage at 22
info : Wrong CRC on datapage at 23
info : Wrong CRC on datapage at 24
info : Wrong CRC on datapage at 25
info : Wrong CRC on datapage at 26
info : Wrong CRC on datapage at 27
info : Wrong CRC on datapage at 28
info : Wrong CRC on datapage at 29
info : Wrong CRC on datapage at 30
info : Wrong CRC on datapage at 31
info : Wrong CRC on datapage at 32
info : Wrong CRC on datapage at 33
info : Wrong CRC on datapage at 34
info : Wrong CRC on datapage at 35
info : Wrong CRC on datapage at 36
info : Wrong CRC on datapage at 37
info : Wrong CRC on datapage at 38
info : Wrong CRC on datapage at 39
info : Wrong CRC on datapage at 40
info : Wrong CRC on datapage at 41
info : Wrong CRC on datapage at 42
info : Wrong CRC on datapage at 43
info : Wrong CRC on datapage at 44
info : Wrong CRC on datapage at 45
info : Wrong CRC on datapage at 46
info : Wrong CRC on datapage at 47
info : Wrong CRC on datapage at 48
info : Wrong CRC on datapage at 49
info : Wrong CRC on datapage at 50
info : Wrong CRC on datapage at 51
info : Wrong CRC on datapage at 52
info : Wrong CRC on datapage at 53
info : Wrong CRC on datapage at 54
info : Wrong CRC on datapage at 55
info : Wrong CRC on datapage at 56
info : Wrong CRC on datapage at 57
info : Wrong CRC on datapage at 58
info : Wrong CRC on datapage at 59
info : Wrong CRC on datapage at 60
info : Wrong CRC on datapage at 61
info : Wrong CRC on datapage at 62
info : Wrong CRC on datapage at 63
info : Wrong CRC on datapage at 64
info : Wrong CRC on datapage at 65
info : Wrong CRC on datapage at 66
info : Wrong CRC on datapage at 67
info : Wrong CRC on datapage at 68
info : Wrong CRC on datapage at 69
info : Wrong CRC on datapage at 70
info : Wrong CRC on datapage at 71
info : Wrong CRC on datapage at 72
info : Wrong CRC on datapage at 73
info : Wrong CRC on datapage at 74
info : Wrong CRC on datapage at 75
info : Wrong CRC on datapage at 76
info : Wrong CRC on datapage at 77
info : Wrong CRC on datapage at 78
info : Wrong CRC on datapage at 79
info : Wrong CRC on datapage at 80
info : Wrong CRC on datapage at 81
info : Wrong CRC on datapage at 82
info : Wrong CRC on datapage at 83
info : Wrong CRC on datapage at 84
info : Wrong CRC on datapage at 85
info : Wrong CRC on datapage at 86
info : Wrong CRC on datapage at 87
info : Wrong CRC on datapage at 88
info : Wrong CRC on datapage at 89
info : Wrong CRC on datapage at 90
info : Wrong CRC on datapage at 91
info : Wrong CRC on datapage at 92
info : Wrong CRC on datapage at 93
info : Wrong CRC on datapage at 94
info : Wrong CRC on datapage at 95
info : Wrong CRC on datapage at 96
info : Wrong CRC on datapage at 97
info : Wrong CRC on datapage at 98
info : Wrong CRC on datapage at 99
info : Wrong CRC on datapage at 100
info : Wrong CRC on datapage at 101
info : Wrong CRC on datapage at 102
info : Wrong CRC on datapage at 103
info : Wrong CRC on datapage at 104
info : Wrong CRC on datapage at 105
info : Wrong CRC on datapage at 106
info : Wrong CRC on datapage at 107
info : Wrong CRC on datapage at 108
info : Wrong CRC on datapage at 109
info : Wrong CRC on datapage at 110
info : Wrong CRC on datapage at 111
info : Wrong CRC on datapage at 112
info : Wrong CRC on datapage at 113
info : Wrong CRC on datapage at 114
info : Wrong CRC on datapage at 115
info : Wrong CRC on datapage at 116
info : Wrong CRC on datapage at 117
info : Wrong CRC on datapage at 118
info : Wrong CRC on datapage at 119
info : Wrong CRC on datapage at 120
info : Wrong CRC on datapage at 121
info : Wrong CRC on datapage at 122
info : Wrong CRC on datapage at 123
info : Wrong CRC on datapage at 124
info : Wrong CRC on datapage at 125
info : Wrong CRC on datapage at 126
info : Wrong CRC on datapage at 127
info : Wrong CRC on datapage at 128
info : Wrong CRC on datapage at 129
info : Wrong CRC on datapage at 130
info : Wrong CRC on datapage at 131
info : Wrong CRC on datapage at 132
info : Wrong CRC on datapage at 133
info : Wrong CRC on datapage at 134
info : Wrong CRC on datapage at 135
info : Wrong CRC on datapage at 136
info : Wrong CRC on datapage at 137
info : Wrong CRC on datapage at 138
info : Wrong CRC on datapage at 139
info : Wrong CRC on datapage at 140
info : Wrong CRC on datapage at 141
info : Wrong CRC on datapage at 142
info : Wrong CRC on datapage at 143
info : Wrong CRC on datapage at 144
info : Wrong CRC on datapage at 145
info : Wrong CRC on datapage at 146
info : Wrong CRC on datapage at 147
info : Wrong CRC on datapage at 148
info : Wrong CRC on datapage at 149
info : Wrong CRC on datapage at 150
info : Wrong CRC on datapage at 151
info : Wrong CRC on datapage at 152
info : Wrong CRC on datapage at 153
info : Wrong CRC on datapage at 154
info : Wrong CRC on datapage at 155
info : Wrong CRC on datapage at 156
info : Wrong CRC on datapage at 157
info : Wrong CRC on datapage at 158
info : Wrong CRC on datapage at 159
info : Wrong CRC on datapage at 160
info : Wrong CRC on datapage at 161
info : Wrong CRC on datapage at 162
info : Wrong CRC on datapage at 163
info : Wrong CRC on datapage at 164
info : Wrong CRC on datapage at 165
info : Wrong CRC on datapage at 166
info : Wrong CRC on datapage at 167
info : Wrong CRC on datapage at 168
info : Wrong CRC on datapage at 169
info : Wrong CRC on datapage at 170
info : Wrong CRC on datapage at 171
info : Wrong CRC on datapage at 172
info : Wrong CRC on datapage at 173
info : Wrong CRC on datapage at 174
info : Wrong CRC on datapage at 175
info : Wrong CRC on datapage at 176
info : Wrong CRC on datapage at 177
info : Wrong CRC on datapage at 178
info : Wrong CRC on datapage at 179
info : Wrong CRC on datapage at 180
info : Wrong CRC on datapage at 181
info : Wrong CRC on datapage at 182
info : Wrong CRC on datapage at 183
info : Wrong CRC on datapage at 184
info : Wrong CRC on datapage at 185
info : Wrong CRC on datapage at 186
info : Wrong CRC on datapage at 187
info : Wrong CRC on datapage at 188
info : Wrong CRC on datapage at 189
info : Wrong CRC on datapage at 190
info : Wrong CRC on datapage at 191
info : Wrong CRC on datapage at 192
info : Wrong CRC on datapage at 193
info : Wrong CRC on datapage at 194
info : Wrong CRC on datapage at 195
info : Wrong CRC on datapage at 196
info : Wrong CRC on datapage at 197
info : Wrong CRC on datapage at 198
info : Wrong CRC on datapage at 199
info : Wrong CRC on datapage at 200
info : Wrong CRC on datapage at 201
info : Wrong CRC on datapage at 202
info : Wrong CRC on datapage at 203
info : Wrong CRC on datapage at 204
info : Wrong CRC on datapage at 205
info : Wrong CRC on datapage at 206
info : Wrong CRC on datapage at 207
info : Wrong CRC on datapage at 208
info : Wrong CRC on datapage at 209
info : Wrong CRC on datapage at 210
info : Wrong CRC on datapage at 211
info : Wrong CRC on datapage at 212
info : Wrong CRC on datapage at 213
info : Wrong CRC on datapage at 214
info : Wrong CRC on datapage at 215
info : Wrong CRC on datapage at 216
info : Wrong CRC on datapage at 217
info : Wrong CRC on datapage at 218
info : Wrong CRC on datapage at 219
info : Wrong CRC on datapage at 220
info : Wrong CRC on datapage at 221
info : Wrong CRC on datapage at 222
info : Wrong CRC on datapage at 223
info : Wrong CRC on datapage at 224
info : Wrong CRC on datapage at 225
info : Wrong CRC on datapage at 226
info : Wrong CRC on datapage at 227
info : Wrong CRC on datapage at 228
info : Wrong CRC on datapage at 229
info : Wrong CRC on datapage at 230
info : Wrong CRC on datapage at 231
info : Wrong CRC on datapage at 232
info : Wrong CRC on datapage at 233
info : Wrong CRC on datapage at 234
info : Wrong CRC on datapage at 235
info : Wrong CRC on datapage at 236
info : Wrong CRC on datapage at 237
info : Wrong CRC on datapage at 238
info : Wrong CRC on datapage at 239
info : Wrong CRC on datapage at 240
info : Wrong CRC on datapage at 241
info : Wrong CRC on datapage at 242
info : Wrong CRC on datapage at 243
info : Wrong CRC on datapage at 244
info : Wrong CRC on datapage at 245
info : Wrong CRC on datapage at 246
info : Wrong CRC on datapage at 247
info : Wrong CRC on datapage at 248
info : Wrong CRC on datapage at 249
info : Wrong CRC on datapage at 250
info : Wrong CRC on datapage at 251
info : Wrong CRC on datapage at 252
info : Wrong CRC on datapage at 253
info : Wrong CRC on datapage at 254
info : Wrong CRC on datapage at 255
info : Wrong CRC on datapage at 256
info : Wrong CRC on datapage at 257
info : Wrong CRC on datapage at 258
info : Wrong CRC on datapage at 259
info : Wrong CRC on datapage at 260
info : Wrong CRC on datapage at 261
info : Wrong CRC on datapage at 262
info : Wrong CRC on datapage at 263
info : Wrong CRC on datapage at 264
info : Wrong CRC on datapage at 265
info : Wrong CRC on datapage at 266
info : Wrong CRC on datapage at 267
info : Wrong CRC on datapage at 268
info : Wrong CRC on datapage at 269
info : Wrong CRC on datapage at 270
info : Wrong CRC on datapage at 271
info : Wrong CRC on datapage at 272
info : Wrong CRC on datapage at 273
info : Wrong CRC on datapage at 274
info : Wrong CRC on datapage at 275
info : Wrong CRC on datapage at 276
info : Wrong CRC on datapage at 277
info : Wrong CRC on datapage at 278
info : Wrong CRC on datapage at 279
info : Wrong CRC on datapage at 280
info : Wrong CRC on datapage at 281
info : Wrong CRC on datapage at 282
info : Wrong CRC on datapage at 283
info : Wrong CRC on datapage at 284
info : Wrong CRC on datapage at 285
info : Wrong CRC on datapage at 286
info : Wrong CRC on datapage at 287
info : Wrong CRC on datapage at 288
info : Wrong CRC on datapage at 289
info : Wrong CRC on datapage at 290
info : Wrong CRC on datapage at 291
info : Wrong CRC on datapage at 292
info : Wrong CRC on datapage at 293
info : Wrong CRC on datapage at 294
info : Wrong CRC on datapage at 295
info : Wrong CRC on datapage at 296
info : Wrong CRC on datapage at 297
info : Wrong CRC on datapage at 298
info : Wrong CRC on datapage at 299
info : Wrong CRC on datapage at 300
info : Wrong CRC on datapage at 301
info : Wrong CRC on datapage at 302
info : Wrong CRC on datapage at 303
info : Wrong CRC on datapage at 304
info : Wrong CRC on datapage at 305
info : Wrong CRC on datapage at 306
info : Wrong CRC on datapage at 307
info : Wrong CRC on datapage at 308
info : Wrong CRC on datapage at 309
info : Wrong CRC on datapage at 310
info : Wrong CRC on datapage at 311
info : Wrong CRC on datapage at 312
info : Wrong CRC on datapage at 313
info : Wrong CRC on datapage at 314
info : Wrong CRC on datapage at 315
info : Wrong CRC on datapage at 316
info : Wrong CRC on datapage at 317
info : Wrong CRC on datapage at 318
info : Wrong CRC on datapage at 319
info : Wrong CRC on datapage at 320
info : Wrong CRC on datapage at 321
info : Wrong CRC on datapage at 322
info : Wrong CRC on datapage at 323
info : Wrong CRC on datapage at 324
info : Wrong CRC on datapage at 325
info : Wrong CRC on datapage at 326
info : Wrong CRC on datapage at 327
info : Wrong CRC on datapage at 328
info : Wrong CRC on datapage at 329
info : Wrong CRC on datapage at 330
info : Wrong CRC on datapage at 331
info : Wrong CRC on datapage at 332
info : Wrong CRC on datapage at 333
info : Wrong CRC on datapage at 334
info : Wrong CRC on datapage at 335
info : Wrong CRC on datapage at 336
info : Wrong CRC on datapage at 337
info : Wrong CRC on datapage at 338
info : Wrong CRC on datapage at 339
info : Wrong CRC on datapage at 340
info : Wrong CRC on datapage at 341
info : Wrong CRC on datapage at 342
info : Wrong CRC on datapage at 343
info : Wrong CRC on datapage at 344
info : Wrong CRC on datapage at 345
info : Wrong CRC on datapage at 346
info : Wrong CRC on datapage at 347
info : Wrong CRC on datapage at 348
info : Wrong CRC on datapage at 349
info : Wrong CRC on datapage at 350
info : Wrong CRC on datapage at 351
info : Wrong CRC on datapage at 352
info : Wrong CRC on datapage at 353
info : Wrong CRC on datapage at 354
info : Wrong CRC on datapage at 355
info : Wrong CRC on datapage at 356
info : Wrong CRC on datapage at 357
info : Wrong CRC on datapage at 358
info : Wrong CRC on datapage at 359
info : Wrong CRC on datapage at 360
info : Wrong CRC on datapage at 361
info : Wrong CRC on datapage at 362
info : Wrong CRC on datapage at 363
info : Wrong CRC on datapage at 364
info : Wrong CRC on datapage at 365
info : Wrong CRC on datapage at 366
info : Wrong CRC on datapage at 367
info : Wrong CRC on datapage at 368
info : Wrong CRC on datapage at 369
info : Wrong CRC on datapage at 370
info : Wrong CRC on datapage at 371
info : Wrong CRC on datapage at 372
info : Wrong CRC on datapage at 373
info : Wrong CRC on datapage at 374
info : Wrong CRC on datapage at 375
info : Wrong CRC on datapage at 376
info : Wrong CRC on datapage at 377
info : Wrong CRC on datapage at 378
info : Wrong CRC on datapage at 379
info : Wrong CRC on datapage at 380
info : Wrong CRC on datapage at 381
info : Wrong CRC on datapage at 382
info : Wrong CRC on datapage at 383
info : Wrong CRC on datapage at 384
info : Wrong CRC on datapage at 385
info : Wrong CRC on datapage at 386
info : Wrong CRC on datapage at 387
info : Wrong CRC on datapage at 388
info : Wrong CRC on datapage at 389
info : Wrong CRC on datapage at 390
info : Wrong CRC on datapage at 391
info : Wrong CRC on datapage at 392
info : Wrong CRC on datapage at 393
info : Wrong CRC on datapage at 394
info : Wrong CRC on datapage at 395
info : Wrong CRC on datapage at 396
info : Wrong CRC on datapage at 397
info : Wrong CRC on datapage at 398
info : Wrong CRC on datapage at 399
info : Wrong CRC on datapage at 400
info : Wrong CRC on datapage at 401
info : Wrong CRC on datapage at 402
info : Wrong CRC on datapage at 403
info : Wrong CRC on datapage at 404
info : Wrong CRC on datapage at 405
info : Wrong CRC on datapage at 406
info : Wrong CRC on datapage at 407
info : Wrong CRC on datapage at 408
info : Wrong CRC on datapage at 409
info : Wrong CRC on datapage at 410
info : Wrong CRC on datapage at 411
info : Wrong CRC on datapage at 412
info : Wrong CRC on datapage at 413
info : Wrong CRC on datapage at 414
info : Wrong CRC on datapage at 415
info : Wrong CRC on datapage at 416
info : Wrong CRC on datapage at 417
info : Wrong CRC on datapage at 418
info : Wrong CRC on datapage at 419
info : Wrong CRC on datapage at 420
info : Wrong CRC on datapage at 421
info : Wrong CRC on datapage at 422
info : Wrong CRC on datapage at 423
info : Wrong CRC on datapage at 424
info : Wrong CRC on datapage at 425
info : Wrong CRC on datapage at 426
info : Wrong CRC on datapage at 427
info : Wrong CRC on datapage at 428
info : Wrong CRC on datapage at 429
info : Wrong CRC on datapage at 430
info : Wrong CRC on datapage at 431
info : Wrong CRC on datapage at 432
info : Wrong CRC on datapage at 433
info : Wrong CRC on datapage at 434
info : Wrong CRC on datapage at 435
info : Wrong CRC on datapage at 436
info : Wrong CRC on datapage at 437
info : Wrong CRC on datapage at 438
info : Wrong CRC on datapage at 439
info : Wrong CRC on datapage at 440
info : Wrong CRC on datapage at 441
info : Wrong CRC on datapage at 442
info : Wrong CRC on datapage at 443
info : Wrong CRC on datapage at 444
info : Wrong CRC on datapage at 445
info : Wrong CRC on datapage at 446
info : Wrong CRC on datapage at 447
info : Wrong CRC on datapage at 448
info : Wrong CRC on datapage at 449
info : Wrong CRC on datapage at 450
info : Wrong CRC on datapage at 451
info : Wrong CRC on datapage at 452
info : Wrong CRC on datapage at 453
info : Wrong CRC on datapage at 454
info : Wrong CRC on datapage at 455
info : Wrong CRC on datapage at 456
info : Wrong CRC on datapage at 457
info : Wrong CRC on datapage at 458
info : Wrong CRC on datapage at 459
info : Wrong CRC on datapage at 460
info : Wrong CRC on datapage at 461
info : Wrong CRC on datapage at 462
info : Wrong CRC on datapage at 463
info : Wrong CRC on datapage at 464
info : Wrong CRC on datapage at 465
info : Wrong CRC on datapage at 466
info : Wrong CRC on datapage at 467
info : Wrong CRC on datapage at 468
info : Wrong CRC on datapage at 469
info : Wrong CRC on datapage at 470
info : Wrong CRC on datapage at 471
info : Wrong CRC on datapage at 472
info : Wrong CRC on datapage at 473
info : Wrong CRC on datapage at 474
info : Wrong CRC on datapage at 475
info : Wrong CRC on datapage at 476
info : Wrong CRC on datapage at 477
info : Wrong CRC on datapage at 478
info : Wrong CRC on datapage at 479
info : Wrong CRC on datapage at 480
info : Wrong CRC on datapage at 481
info : Wrong CRC on datapage at 482
info : Wrong CRC on datapage at 483
info : Wrong CRC on datapage at 484
info : Wrong CRC on datapage at 485
info : Wrong CRC on datapage at 486
info : Wrong CRC on datapage at 487
info : Wrong CRC on datapage at 488
info : Wrong CRC on datapage at 489
info : Wrong CRC on datapage at 490
info : Wrong CRC on datapage at 491
info : Wrong CRC on datapage at 492
info : Wrong CRC on datapage at 493
info : Wrong CRC on datapage at 494
info : Wrong CRC on datapage at 495
info : Wrong CRC on datapage at 496
info : Wrong CRC on datapage at 497
info : Wrong CRC on datapage at 498
info : Wrong CRC on datapage at 499
info : Wrong CRC on datapage at 500
info : Wrong CRC on datapage at 501
info : Wrong CRC on datapage at 502
info : Wrong CRC on datapage at 503
info : Wrong CRC on datapage at 504
info : Wrong CRC on datapage at 505
info : Wrong CRC on datapage at 506
info : Wrong CRC on datapage at 507
info : Wrong CRC on datapage at 508
info : Wrong CRC on datapage at 509
info : Wrong CRC on datapage at 510
info : Wrong CRC on datapage at 511
info : Wrong CRC on datapage at 512
info : Wrong CRC on datapage at 513
info : Wrong CRC on datapage at 514
info : Wrong CRC on datapage at 515
info : Wrong CRC on datapage at 516
info : Wrong CRC on datapage at 517
info : Wrong CRC on datapage at 518
info : Wrong CRC on datapage at 519
info : Wrong CRC on datapage at 520
info : Wrong CRC on datapage at 521
info : Wrong CRC on datapage at 522
status : OK
mysql.event OK
mysql.func OK
mysql.global_priv
warning : Number of rows changed from 0 to 6
status : OK
mysql.gtid_slave_pos
note : The storage engine for the table doesn't support repair
mysql.help_category
warning : Number of rows changed from 0 to 40
status : OK
mysql.help_keyword
warning : Number of rows changed from 0 to 475
status : OK
mysql.help_relation
warning : Number of rows changed from 0 to 1059
status : OK
mysql.help_topic
warning : Number of rows changed from 0 to 529
status : OK
mysql.index_stats OK
mysql.innodb_index_stats
note : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note : The storage engine for the table doesn't support repair
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv
warning : Number of rows changed from 0 to 1
status : OK
mysql.roles_mapping OK
mysql.servers OK
mysql.slave_master_info
note : The storage engine for the table doesn't support repair
mysql.slave_relay_log_info
note : The storage engine for the table doesn't support repair
mysql.slave_worker_info
note : The storage engine for the table doesn't support repair
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry
note : The storage engine for the table doesn't support repair


Endresult: my database is still broken and I get the same messages in the Xampp console.
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows

Re: XAMPP startet MySQL nicht mehr

Postby Altrea » 02. February 2022 17:09

Please try the following fix. It already helped lots of users solving the multi-master Problem:

  • Open your folder "\xampp\mysql\data"
  • 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-"
  • Delete all files beginning with "ib_logfile"
  • Delete all files beginning with "aria_log."

Now try to start mariadb the normal way again.
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

Re: XAMPP startet MySQL nicht mehr

Postby musicmaster » 03. February 2022 14:01

I experimented with deleting files in the data directory but it doesn't solve things.

As far as I can see the problem is the data/mysql database. When I run aria_chk on those tables I get the same effect as with the mysqlcheck command mentioned above but it gives some more diagnostic info. There are several tables that report problems when I run aria_chk without a fix flag but it looks like the db table is the main problem. It is truncated from 420K to 8K.

After the aria_chk/mysqlcheck fix I can start the database with Xampp. However, I cannot login as a user.

When I run aria_chk with the -e option (row fix) I get this output:

Checking Aria file: db.MAI
Data records: 4 Deleted blocks: 0
aria_chk.exe: warning: Table is marked as crashed and last repair failed
aria_chk.exe: warning: Table create_trd (92) > current max_transaction id (0). Table needs to be repaired or zerofilled to be usable
- check file-size
aria_chk.exe: warning: Size of indexfile is: 26996 Expected: 8192
aria_chk.exe: warning: Size of datafile is: 4286794 Expected: 16384
- check key delete-chain
- check index reference
- check data record references index: 1
aria_chk.exe: error: Key tree 1 is empty
- check data record references index: 2
aria_chk.exe: error: Key tree 2 is empty
- check records and index references
aria_chk.exe: error: Page 0: Got error: 176 when reading datafile
Aria table 'db.MAI' is corrupted
Fix it using switch "-r" or "-o"
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows

Re: XAMPP startet MySQL nicht mehr

Postby Altrea » 03. February 2022 14:59

musicmaster wrote:I experimented with deleting files in the data directory but it doesn't solve things.

This could be because you didn't deleted all needed files to solve the multi-master.info issue. So don't experiment, do what i have written.
Related to your shown logs you still have a master-info replication issue which needs to be addressed first.

It could be possible that you have two issues at the same time.

AFTER THAT, you can try to fix the mysql table.
To do this please open the XAMPP Shell by clicking the Shell button in your XAMPP Control Panel and execute the following command:
Code: Select all
mysqld --console --skip-grant-tables --skip-external-locking


Leave this black command line window open and click on the Shell button in the Control Panel again to open a second command line window and execute this command:
Code: Select all
mysqlcheck -r --databases mysql --use-frm


After that you Can close both command line Windows and try to start MariaDB again normally from your XAMPP control panel
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

Re: XAMPP startet MySQL nicht mehr

Postby musicmaster » 03. February 2022 16:06

This has the familiar result:

- after deleting the mentioned files and starting up Mysql closes down after 5 minutes
- when I then apply the mysqld/mysqlcheck commands I see with the check the familiar errors that I mentioned previously and that center on the mysql/db table - that is greatly reduced in size.
- after that starting Mysql works. However, I am not able to login with my applications.
musicmaster
 
Posts: 34
Joined: 07. July 2016 19:47
XAMPP version: latest
Operating System: Windows


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 44 guests