hi,
again, thank for the help.
i done:
- Code: Select all
mysqld --console --skip-grant-tables --skip-external-locking
and get:
2021-12-03 9:12:25 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.
2021-12-03 9:12:25 0 [Note] mysqld (mysqld 10.4.8-MariaDB) starting as process 12488 ...
InnoDB: using atomic writes.
2021-12-03 9:12:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-03 9:12:25 0 [Note] InnoDB: Uses event mutexes
2021-12-03 9:12:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-03 9:12:25 0 [Note] InnoDB: Number of pools: 1
2021-12-03 9:12:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-03 9:12:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-03 9:12:25 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-03 9:12:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-03 9:12:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-03 9:12:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-03 9:12:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-03 9:12:26 0 [Note] InnoDB: Waiting for purge to start
2021-12-03 9:12:26 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669799; transaction id 35411
2021-12-03 9:12:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-03 9:12:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-03 9:12:26 0 [Note] Server socket created on IP: '::'.
2021-12-03 9:12:26 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 9:12:26
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_leap_second'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_name'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition_type'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition'
2021-12-03 9:12:26 0 [Note] Reading of all Master_info entries succeeded
2021-12-03 9:12:26 0 [Note] Added new Master_info '' to hash table
2021-12-03 9:12:26 0 [Note] mysqld: ready for connections.
then in the other second shell, i done
- Code: Select all
mysqlcheck -r --databases mysql --use-frm
and get:
mysql.column_stats OK
mysql.columns_priv OK
mysql.db
info : Wrong CRC on datapage at 1
status : OK
mysql.event OK
mysql.func OK
mysql.global_priv
warning : Number of rows changed from 0 to 4
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 48
status : OK
mysql.help_keyword
warning : Number of rows changed from 0 to 37
status : OK
mysql.help_relation
warning : Number of rows changed from 0 to 114
status : OK
mysql.help_topic
warning : Number of rows changed from 0 to 752
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.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
after the 2nd command line, the first one display have been updated with :
Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2021-12-03 9:13:34 8 [Note] Found 4 of 0 rows when repairing '.\mysql\global_priv'
2021-12-03 9:13:34 8 [Note] Found 48 of 0 rows when repairing '.\mysql\help_category'
2021-12-03 9:13:34 8 [Note] Found 37 of 0 rows when repairing '.\mysql\help_keyword'
2021-12-03 9:13:34 8 [Note] Found 114 of 0 rows when repairing '.\mysql\help_relation'
2021-12-03 9:13:34 8 [Note] Found 752 of 0 rows when repairing '.\mysql\help_topic'
2021-12-03 9:13:34 8 [Note] Found 1 of 0 rows when repairing '.\mysql\proxies_priv'
then, i started mysql by hitting the start button in the panel, and it looks it's running.
after that, i check the error log fro mthis 2 commands line and get that :
InnoDB: using atomic writes.
2021-12-03 9:11:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-03 9:11:23 0 [Note] InnoDB: Uses event mutexes
2021-12-03 9:11:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-03 9:11:23 0 [Note] InnoDB: Number of pools: 1
2021-12-03 9:11:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-03 9:11:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-03 9:11:23 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-03 9:11:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-03 9:11:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-03 9:11:23 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-03 9:11:23 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-03 9:11:23 0 [Note] InnoDB: Waiting for purge to start
2021-12-03 9:11:23 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669790; transaction id 35411
2021-12-03 9:11:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-03 9:11:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-03 9:11:23 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 9:11:23
2021-12-03 9:11:23 0 [Note] Server socket created on IP: '::'.
2021-12-03 9:18:55 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 18% 28% 41% 55% 67% 79% 94% 100% (0.0 seconds); tables to flush: 2 1 0
(0.0 seconds);
2021-12-03 9:18:55 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2021-12-03 9:18:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-03 9:18:55 0 [Note] InnoDB: Uses event mutexes
2021-12-03 9:18:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-03 9:18:55 0 [Note] InnoDB: Number of pools: 1
2021-12-03 9:18:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-03 9:18:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-03 9:18:55 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-03 9:18:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=15669799
2021-12-03 9:18:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-03 9:18:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-12-03 9:18:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-03 9:18:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-03 9:18:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-03 9:18:55 0 [Note] InnoDB: Waiting for purge to start
2021-12-03 9:18:55 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669808; transaction id 35411
2021-12-03 9:18:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-03 9:18:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-03 9:18:55 0 [Note] Zerofilling moved table: '.\mysql\plugin'
2021-12-03 9:18:55 0 [Note] Zerofilling moved table: '.\mysql\servers'
2021-12-03 9:18:55 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 9:18:55
2021-12-03 9:18:55 0 [Note] Server socket created on IP: '::'.
then i will check the databases, i hope none have been "broken".
Thank you again for the help.
by the way, do you have any idea of what was heppened?
Important question :
do you have a documentation of what the folder xamp/mysql/backup should contains ? the periodic backup in there ? because for me, there is only ONE TIME backup there , not everyday. i thought xamp will perform automatic backup in this folder, but i doubt of that now. by judging the dates in xamp/mysql/backup , it only backuped the day i installed the application.
Best regards