Altrea wrote:Search for the following files in your \xampp\mysql\ folder and delete them:
- ib_logfile0
- ib_logfile1
- aria_log_control
i have same error i remove ib_logfile0
ib_logfile1
aria_log_control
the same error at
# mysqlcheck -r --databases mysql --use-frm
mysqlcheck: Got error: 2002: Can't connect to MySQL server on 'localhost' (10061) when trying to connect
and this result for step 1
mysqld --console --skip-grant-tables --skip-external-locking
Setting environment for using XAMPP for Windows.
pc@DESKTOP-0SR7FM4 d:\xampp
# mysqld --console --skip-grant-tables --skip-external-locking
2022-12-13 17:36:35 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-12-13 17:36:35 0 [Note] mysqld (mysqld 10.3.16-MariaDB) starting as process 20160 ...
2022-12-13 17:36:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-12-13 17:36:35 0 [Note] InnoDB: Uses event mutexes
2022-12-13 17:36:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-12-13 17:36:35 0 [Note] InnoDB: Number of pools: 1
2022-12-13 17:36:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-12-13 17:36:35 0 [Note] InnoDB: Initializing buffer pool, total size = 10M, instances = 1, chunk size = 10M
2022-12-13 17:36:35 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-13 17:36:35 0 [Note] InnoDB: Setting log file D:\XAMPP\mysql\data\ib_logfile101 size to 5242880 bytes
2022-12-13 17:36:35 0 [Note] InnoDB: Setting log file D:\XAMPP\mysql\data\ib_logfile1 size to 5242880 bytes
2022-12-13 17:36:35 0 [Note] InnoDB: Renaming log file D:\XAMPP\mysql\data\ib_logfile101 to D:\XAMPP\mysql\data\ib_logfile0
2022-12-13 17:36:35 0 [Note] InnoDB: New log files created, LSN=12258325
2022-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=4] log sequence number 17043745 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=11] log sequence number 20611167 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=440] log sequence number 16300021 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=1] log sequence number 18258507 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=8] log sequence number 20697514 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=338] log sequence number 20706088 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=10] log sequence number 21693978 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=12] log sequence number 20832095 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=442] log sequence number 16777820 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=307] log sequence number 17188194 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=308] log sequence number 17188236 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=470] log sequence number 84466255 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:35 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=471] log sequence number 105019670 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=473] log sequence number 132722288 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=340] log sequence number 21846409 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=341] log sequence number 21847386 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=342] log sequence number 20697514 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=359] log sequence number 17843375 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=375] log sequence number 17188236 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=363] log sequence number 147185420 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=360] log sequence number 147215246 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=460] log sequence number 131220616 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=474] log sequence number 131220616 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=410] log sequence number 109449761 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=479] log sequence number 110625824 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=441] log sequence number 17998905 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=444] log sequence number 37464476 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=452] log sequence number 81928836 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=465] log sequence number 85966914 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=466] log sequence number 89917403 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=490] log sequence number 102392339 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 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-12-13 17:36:36 0 [ERROR] InnoDB: Page [page id: space=0, page number=511] log sequence number 106336569 is in the future! Current system log sequence number 12258837.
2022-12-13 17:36:36 0 [ERROR] InnoDB: Your dat0020initialized@0020master_info@0020from@0020@0027master@002d2022@0040002d12@0040002d13@00400020@004000209@0040003a30@0040003a31@004000207@00400020@0040005berror@0040005d@00400020failed@00400020to@00400020create@00400020a@00400020new@00400020master@0040.info'
2022-12-13 17:36:40 7 [ERROR] Failed to create a new master info file (file 'D:\XAMPP\mysql\data\master-2022@002d12@002d13@002010@003a11@003a10@00207@0020@005berror@005d@0020initialized@0020master_info@0020from@0020@0027master@0@003a31@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d12@0040002d13@00400020@004000208@0040003a42@0040003a44@004000207@00400020@00.info' Relay_info:'relay-log-2022@002d12@002d13@002010@003a11@003a10@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272022@002d12@002d13@0020@00209@003a30@003a31@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d12@0040002d13@00400020@004000208@0040003a42@0040003a44@004000207@00400020@00.info'
2022-12-13 17:36:40 7 [ERROR] Failed to create a new master info file (file 'D:\XAMPP\mysql\data\master-2022@002d12@002d13@002010@003a11@003a10@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272022@002d12@002d13@0020@00209@003a30@003a31@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d12@0040002d13@00400020@004000208@0040003a42@0040003a44@004000207@00400020@00.info', errno 2)
2022-12-13 17:36:40 7 [ERROR] Initialized Master_info from 'master-2022@002d12@002d13@002010@003a11@003a10@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272022@002d12@002d13@0020@00209@003a30@003a31@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d12@0040002d13@00400020@004000208@0040003a42@0040003a44@004000207@00400020@00.info' failed
2022-12-13 17:36:40 7 [Note] Added new Master_info '2022-12-13 10:11:10 7 [Note] Added new Master_info '2022-12-13 9:30:31 7 [Note] Reading Master_info: 'master-2022@002d12@002d13@0020@00208@003a42@003a44@00207@0020@005bnote@005d@0020added@002' to hash table
2022-12-13 17:36:40 7 [Note] Reading Master_info: 'master-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_infarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info'
2022-12-13 17:36:40 7 [Note] Added new Master_info '2022-12-13 10:11:10 0 [Warning] Reading of some Master_info entries ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4nfo entries failed
2022-12-13 17:36:40 7 [Note] Started replication for '2022-12-13 10:11:10 0 [Warning] Reading of some Master_info entrie' failed
': 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-12-13 17:36:40 7 [Note] Reading Master_info: 'master-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@002005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.000009' position: 4
': Slave I/O thread killed while connecting to master1:10 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread exiting, read up to log 'FIRST', position 4rning] Reading of some Master_info entries failed
2022-12-13 17:36:40 7 [Note] Initialized Master_info from 'master-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info'
2022-12-13 17:36:40 7 [Note] Added new Master_info '2022-12-13 10:11:10 0 [ERROR] Failed to initialize multi master stru' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 master structures
': 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-12-13 17:36:40 7 [Note] Started replication for '2022-12-13 10:11:10 0 [ERROR] Failed to initialize multi master st'uctures
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.000009' position: 4
': Slave I/O thread killed while connecting to master1:10 0 [ERROR] Failed to initialize multi master structures
': Slave I/O thread exiting, read up to log 'FIRST', position 4ROR] Failed to initialize multi master structures
2022-12-13 17:36:40 7 [Note] Reading Master_info: 'master-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005berror@005d@0020aborting@000d.info' Relay_info:'relay-log-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005berror@005d@0020aborting@000d.info'
2022-12-13 17:36:40 7 [Note] Initialized Master_info from 'master-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005berror@005d@0020aborting@000d.info'
' to hash table6:40 7 [Note] Added new Master_info '2022-12-13 10:11:10 0 [ERROR] Aborting
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
'022-12-13 17:36:40 7 [Note] Started replication for '2022-12-13 10:11:10 0 [ERROR] Aborting
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2022@002d12@002d13@002010@003a11@003a10@00200@0020@005berror@005d@0020aborting@000d.000009' position: 4
': 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-12-13 17:36:40 7 [Note] Reading Master_info: 'master-@000d.info' Relay_info:'relay-log-@000d.info'
': Slave I/O thread killed while connecting to master1:10 0 [ERROR] Aborting
': Slave I/O thread exiting, read up to log 'FIRST', position 4ROR] Aborting
2022-12-13 17:36:41 7 [Note] Initialized Master_info from 'master-@000d.info'
' to hash table6:41 7 [Note] Added new Master_info '
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
'022-12-13 17:36:41 7 [Note] Started replication for '
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-@000d.000014' position: 4
2022-12-13 17:36:41 0 [Warning] Reading of some Master_info entries failed
2022-12-13 17:36:41 0 [ERROR] Failed to initialize multi master structures
': 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
2022-12-13 17:36:41 0 [ERROR] Aborting
': Slave I/O thread exiting, read up to log 'FIRST', position 4
pc@DESKTOP-0SR7FM4 d:\xampp
#