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:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-19 9:18:14 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' 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:\xampp\mysql\data\ib_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.
- 打开cmd.
- 在cmd中,转到xampp/mysql/data文件夹.就我而言,我做了以下
cd C:\xampp\mysql\data
- 在该目录中为mysql子文件夹中的所有
.MAI
表运行aria_chk -r
.就我而言,..\bin\aria_chk -r mysql\*.MAI
- 删除所有
aria_log.########
文件.它们位于C:\ xampp \ mysql \ data文件夹中.我只是将它们重命名,以防万一(在其名称的开头添加了old_
). - 再次启动xampp,它应该可以正常工作.
- Open cmd.
- In cmd, go to xampp/mysql/data folder. In my case, I did the following
cd C:\xampp\mysql\data
- Run
aria_chk -r
in that directory for all.MAI
tables in the mysql subfolder. In my case,..\bin\aria_chk -r mysql\*.MAI
- Delete all
aria_log.########
files. They are present in the C:\xampp\mysql\data folder. I just renamed them for just in case (addedold_
in the beginning of their names). - Start xampp again and it should be working.
这篇关于xampp Windows mariadb无法启动的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!