mysql 无法启动
来源:互联网 发布:windows ad管理 文件夾 编辑:程序博客网 时间:2024/05/14 14:47
2013-08-04 13:48:22 760 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace isaactest/wp_usermeta uses space ID: 2 at filepath: .\isaactest\wp_usermeta.ibd. Cannot open tablespace MySQL/innodb_index_stats which uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
出现这个问题好几次了,每次的解决问题都是重新弄下Mysql.
我用的是XAMPP 1.83,今天终于找到解决办法了
在D:\xampp\mysql\bin下面的my.ini中添加
innodb_force_recovery = 1
- mysql无法启动启动
- xammp无法启动mysql?
- mysql无法启动
- mysql服务无法启动
- MySql服务无法启动
- mysql 数据库 无法启动
- mysql 服务无法启动
- mysql 无法启动
- XAMPP无法启动MySql
- XAMPP无法启动MySql
- mysql无法启动
- mysql意外无法启动
- window mysql 无法启动
- Mysql无法启动
- mysql无法启动
- mysql 1067 无法启动
- MYSQL安装无法启动
- mysql 服务无法启动
- leetcode--Bulls and Cows
- 对象作用域与servlet事件监听器
- 如何用代码注册广播接收者
- [置顶] 最全前端资源汇集
- JAVA设计模式(策略模式)
- mysql 无法启动
- 模式识别简介
- lightoj1047 【简单线性DP】
- 如何解决跨域访问的问题
- ubuntu14.04+caffe+cuda-7.5+opencv-3.1.0安装
- CentOS 7 环境下搭建FTP服务器
- JavaScript之错误处理,函数对象
- 钩子函数
- 《项目管理利器Maven》学习(四):Maven核心之坐标和仓库