xampp windows mariadb没有启动 [英] xampp windows mariadb not starting

问题描述

mariaDB 没有在我的 Windows 10 中启动.

mariaDB is not starting in my windows 10.

我在日志中得到以下信息:

I am getting the following in the logs:

Cannot find checkpoint record at LSN (1,0x5c8f)
2019-12-19  9:18:13 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-12-19  9:18:13 0 [ERROR] Plugin 'Aria' init function returned error.
2019-12-19  9:18:13 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2019-12-19  9:18:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-19  9:18:13 0 [Note] InnoDB: Uses event mutexes
2019-12-19  9:18:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-19  9:18:13 0 [Note] InnoDB: Number of pools: 1
2019-12-19  9:18:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-19  9:18:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-12-19  9:18:13 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-19  9:18:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-19  9:18:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-19  9:18:14 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-19  9:18:14 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2019-12-19  9:18:14 0 [Note] InnoDB: Waiting for purge to start
2019-12-19  9:18:14 0 [Note] InnoDB: 10.4.10 started; log sequence number 42992145; transaction id 110929
2019-12-19  9:18:14 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2019-12-19  9:18:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-19  9:18:14 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-12-19  9:18:14 0 [Note] InnoDB: Buffer pool(s) load completed at 191219  9:18:14
2019-12-19  9:18:14 0 [ERROR] Failed to initialize plugins.
2019-12-19  9:18:14 0 [ERROR] Aborting

我四处搜索，找不到解决此问题的方法.Xampp 昨天工作正常，但今天没有启动.所以，我昨天做的是使用 xcloner 将一个 wordpress 网站克隆到我的电脑上.克隆网站后，一切正常.然后，我停止了 mysql 和 apache 并关闭了我的电脑.今天早上，我遇到了这个问题.

I have searched around and could not find a fix for this issue. Xampp was working fine yesterday but did not start today. So, what I did yesterday was to clone a wordpress website to my pc using xcloner. After I cloned the website, everything was working fine. Then, I stopped mysql and apache and shutdown my pc. This morning, I got that issue.

我在其他时候也遇到过同样的问题，我重新安装了 xampp 和 wordpress(bitnami 版本).但是，我一直遇到这个问题.

I had face the same issue other times and I have reinstalled xampp and wordpress (bitnami versions). However, I keep getting that problem.

任何帮助将不胜感激.

推荐答案

在@RiggsFolly 的帮助下，以下解决了我的问题.

With the help of @RiggsFolly, the following solved my issue.

1. 打开 cmd.
2. 在 cmd 中，进入 xampp/mysql/data 文件夹.就我而言，我做了以下 cd C:xamppmysqldata
3. 在该目录中为 mysql 子文件夹中的所有 .MAI 表运行 aria_chk -r.就我而言， ..inaria_chk -r mysql*.MAI
4. 删除所有 aria_log.######## 文件.它们位于 C:xamppmysqldata 文件夹中.为了以防万一，我只是重命名了它们(在它们名称的开头添加了 old_).
5. 再次启动 xampp，它应该可以工作了.

1. Open cmd.
2. In cmd, go to xampp/mysql/data folder. In my case, I did the following cd C:xamppmysqldata
3. Run aria_chk -r in that directory for all .MAI tables in the mysql subfolder. In my case, ..inaria_chk -r mysql*.MAI
4. Delete all aria_log.######## files. They are present in the C:xamppmysqldata folder. I just renamed them for just in case (added old_ in the beginning of their names).
5. Start xampp again and it should be working.

这篇关于xampp windows mariadb没有启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！