Mysql5.6启动报错, [ERROR] InnoDB: Could not find a valid tablespace file for 'pa
来源:互联网 发布:psp4000淘宝 编辑:程序博客网 时间:2024/06/06 02:50
通过xampp1.8.3安装的环境,由于修改了my.cnf配置,kill之前的mysql实例,重启的时候,报错,错误如下:
2014-03-10 13:48:19 7948 [ERROR] InnoDB: Could not find a valid tablespace file for 'paas/nms_link'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.2014-03-10 13:48:19 7948 [ERROR] InnoDB: Tablespace open failed for '"paas"."nms_link"', ignored.2014-03-10 13:48:19 7fd80e6ea700 InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: If you are installing InnoDB, remember that you must createInnoDB: directories yourself, InnoDB does not create them.2014-03-10 13:48:19 7948 [ERROR] InnoDB: Could not find a valid tablespace file for 'paas/nms_node_tooltip_info'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.2014-03-10 13:48:19 7948 [ERROR] InnoDB: Tablespace open failed for '"paas"."nms_node_tooltip_info"', ignored.2014-03-10 13:48:19 7fd80e6ea700 InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: If you are installing InnoDB, remember that you must createInnoDB: directories yourself, InnoDB does not create them.2014-03-10 13:48:19 7948 [ERROR] InnoDB: Could not find a valid tablespace file for 'paas/nms_onus_of_olt'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.2014-03-10 13:48:19 7948 [ERROR] InnoDB: Tablespace open failed for '"paas"."nms_onus_of_olt"', ignored.2014-03-10 13:48:19 7fd80e6ea700 InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: If you are installing InnoDB, remember that you must createInnoDB: directories yourself, InnoDB does not create them.2014-03-10 13:48:19 7948 [ERROR] InnoDB: Could not find a valid tablespace file for 'paas/nms_topo_detect_scan_report'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.2014-03-10 13:48:19 7948 [ERROR] InnoDB: Tablespace open failed for '"paas"."nms_topo_detect_scan_report"', ignored.2014-03-10 13:48:19 7fd80e6ea700 InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: If you are installing InnoDB, remember that you must createInnoDB: directories yourself, InnoDB does not create them.
原因分析:在网上找了半天,说是找不到数据目录导致的
解决办法:在my.cnf[mysqld]中加入 datadir 指定数据存放位置,重启就ok了
问题虽然解决了,但是感觉比较奇怪,为啥找不到数据位置的呢? 安装cmake的时候,指定了 -DMYSQL_DATADIR=/mysql/mysql5.5/data 参数,按道理程序应该能找到这个datadir配置才是
0 0
- Mysql5.6启动报错, [ERROR] InnoDB: Could not find a valid tablespace file for 'pa
- [ERROR] InnoDB: Could not find a valid tablespace file
- hibernate 报错:Could not find a getter for ~
- Mac 下MAMP Pro MySQL无法启动报 Error: could not open single-table tablespace file ./mysql/innodb_table_sta
- jenkins启动报错Error: could not find libjava.so Error: Could not find Java SE Runtime Environment.
- pod install报错:could not find a valid gem 'cocoapods'
- Qt for Android - Internal Error: Could not find .pro file
- log4j:ERROR Could not find value for key log4j.appender.Console 报错解决方法
- Android Studio报错:Error[*,*]Could not find method android() for arguments [……]
- 安装centos 5.9系统,出现Error: Cannot find a valid baseurl for repo: base报错
- 安装centos 5.9系统,出现Error: Cannot find a valid baseurl for repo: base报错
- gmp4.3.2 安装时 ./configure报错: error: could not find a working compiler
- Nginx启动报错: could not open error log file: open()
- rails4.1.6启动报错Could not find a JavaScript runtime
- IAR报错could not find the following source file
- jboss启动报错Could not make local copy for file解决方法
- archive for required library could not be read or is not a valid ZIP file
- 安装xfsprogs:FATAL ERROR: could not find a valid UUID header.
- python sorted函数使用说明
- WIN8 免费的企业级正版Windows安全管理利器——System Center 2012 Endpoint Protection
- U-boot分析第1章------------------Makefile(编译过程)
- 查找SAP增强方法总结
- Ubuntu 默认安装目录
- Mysql5.6启动报错, [ERROR] InnoDB: Could not find a valid tablespace file for 'pa
- WPARAM 和 LPARAM
- Android中一些反编译器工具的使用方法
- WPF样式和行为学习总结
- 性能优化之布局优化
- final相关
- python中xrange和range的异同
- 【分享】武汉江夏豹澥镇某地区27个土壤湿度传感器3个月数据
- MySQL MyISAM/InnoDB高并发优化经验