> 折腾笔记 > Xampp MySql 不能启动记录

Xampp MySql 不能启动记录

折腾笔记

一：错误展示

过完春节回来，忽然就启动不了了，错误日志如下

Cannot find checkpoint record at LSN (1,0x60c9)
2023-01-31 16:47:40 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2023-01-31 16:47:40 0 [ERROR] Plugin 'Aria' init function returned error.
2023-01-31 16:47:40 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-01-31 16:47:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-31 16:47:40 0 [Note] InnoDB: Uses event mutexes
2023-01-31 16:47:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-01-31 16:47:40 0 [Note] InnoDB: Number of pools: 1
2023-01-31 16:47:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-31 16:47:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-31 16:47:40 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-31 16:47:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-31 16:47:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-31 16:47:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-31 16:47:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-31 16:47:40 0 [Note] InnoDB: Waiting for purge to start
2023-01-31 16:47:41 0 [Note] InnoDB: 10.4.27 started; log sequence number 29968412; transaction id 12673
2023-01-31 16:47:41 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-31 16:47:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-31 16:47:41 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2023-01-31 16:47:41 0 [ERROR] Failed to initialize plugins.
2023-01-31 16:47:41 0 [ERROR] Aborting

二：解决办法

不会的东西就要学，搜索引擎好助手，参考链接：
xampp windows mariadb not starting – Stack Overflow

白话版：使用mysql安装目录下bin文件夹下的工具aria_chk检测修复所有数据文件.MAI

  1. 用管理员权限打开cmd，因为我默认安装在系统盘
  2. cd C:\xampp\mysql\data，此为xampp安装路径中的data目录
  3. ..\bin\aria_chk -r mysql\*.MAI，执行检测修复
  4. del aria_log.*，删除当前目录（data）下所有aria_log.########文件

重新启动即可

折腾笔记