XAMPP / MySQL：无法打开单表表空间文件。\mysql\innodb_index_stats.ibd重新启动MySQL后

问题描述

我在我的本地XAMPP服务器上安装了Drupal。它工作所有罚款，没有问题，包括和使用数据库/网站，直到我重新启动XAMPP。从那时起，我在我的日志文件中获得以下内容：

我通过google寻找一个解决方案，但它似乎是一个问题只是与drupal数据库，因为它能够连接MySQL，如果我删除数据库。

我希望有人能帮助我：（。

解决方案

dev_khan，

1. 使用此行重新启动MySQL服务在Config-文件使
   MySQL引擎修复本身。


2. 完成后，您必须删除innodb_force_recovery-Command
   或在命令前使用＃取消注释。

来自德国的问候

重新启动MySql， >

I've installed Drupal on my local XAMPP Server. It worked all fine, no problems with including and working with the database/site till i restarted XAMPP. Since then I get the following at my logfile:

I looked for a solution via google but it seems to be a problem just with the drupal database because it's able to connect with MySQL if I remove the database.

I hope someone could help me :(.

解决方案

dev_khan,you have a Read-Only permission as long as "innodb_force_recovery" is enabled in your configuration file.

1. Restart the MySQL Service with this Line in the Config-File to makethe MySQL engine repairing itself.
2. After it is done you have to drop the innodb_force_recovery-Commandor outcomment it with a "#" before the Command.
3. Restart MySql again and you have full Access again without aRead-Only-Restriction.

Greetings from Germany

这篇关于XAMPP / MySQL：无法打开单表表空间文件。\mysql\innodb_index_stats.ibd重新启动MySQL后的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！