Mysql启动报错, [ERROR] InnoDB: Could not find a valid tablespace file for


64x64
匿名 2017-11-06 22:29 697

mysql在重启的时候,报[ERROR] InnoDB: Could not find a valid tablespace file for错误。

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 create  
InnoDB: 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 create  
InnoDB: 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 create  
InnoDB: 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 create  
InnoDB: directories yourself, InnoDB does not create them.


mysqlstructvue 回答问题

2 个解决方案


1
匿名 2017-11-06T22:31:04

找不到数据目录导致的.

解决方法:

在my.cnf[mysqld]中加设置datadir 指定数据存放位置,重启就ok了。


2
匿名 2017-08-07T17:56:11

这个是window操作系统的问题,检查你import文件的路径跟你项目文件路径,大小写是否一致,

如:E:\App\src\views\Home.vue和E:\App\src\views\home.vue的就存home和Home大小写不一致。


评论