[ERROR] InnoDB: Could not find a valid tablespace file
来源:互联网 发布:伊藤园三得利 知乎 编辑:程序博客网 时间:2024/05/24 06:30
mysql启动报下述错误:
[ERROR] InnoDB: Could not find a valid tablespace file for 'test/sys_log'. Seehttp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
for how to resolve the issue.
原来在异机恢复的时候少拷贝了一张表,把这个表拷贝到data/test目录下
$cp sys_log.frm sys_log.ibd /db/data/test/
mysql> select version();
+-------------------------------------------+
| version() |
+-------------------------------------------+
| 5.6.21-enterprise-commercial-advanced-log |
+-------------------------------------------+
1 row in set (0.00 sec)
mysql> select count(1) from sys_log;
+----------+
| count(1) |
+----------+
| 35596850 |
+----------+
1 row in set (0.00 sec)
$tail -f error.log
[ERROR] InnoDB: Failed to find tablespace for table '"test"."sys_log"' in the cache. Attempting to load the tablespace with space id 174.
- [ERROR] InnoDB: Could not find a valid tablespace file
- Mysql5.6启动报错, [ERROR] InnoDB: Could not find a valid tablespace file for 'pa
- 安装xfsprogs:FATAL ERROR: could not find a valid UUID header.
- ERROR: Could not find a valid gem 'cocoapods' (>= 0) in any repository
- Mxmlc Error: could not find a JVM.
- ERROR: Could not find a valid gem 'cocoapods' (>= 0), here is why: Unable to download dat
- ERROR: Could not find a valid gem 'sass' (>= 0), here is why: Unable to download data from
- Qt for Android - Internal Error: Could not find .pro file
- ERROR StatusLogger Log4j2 could not find a logging implementation.
- Could not open virtual machine – vmx is not a valid virtual machine configuration file
- Could not open virtual machine – vmx is not a valid virtual machine configuration file
- archive for required library could not be read or is not a valid ZIP file
- 安装cocoapods时已经替换成淘宝镜像依然无法成功:ERROR: Could not find a valid gem 'cocoapods' (>= 0), here is why:
- Mac 下MAMP Pro MySQL无法启动报 Error: could not open single-table tablespace file ./mysql/innodb_table_sta
- 出现“Xcode could not find a valid private-key/...”一种解决办法
- xcode 4.2 "XCode could not find a valid private-key/certificate pair for this profile" 解决方案
- 关于“Could not find a valid gem 'bundler' (>= 0) in any repository” 解决办法。
- 遇到Could not find a valid gem 'compass' (>= 0) in any repository
- android之位置坐标
- UVaOJ490旋转句子
- 深入mysql外键关联问题的详解(下)
- iOS 5 Storyboard 学习之 Tabbar Controller,Navigation Controller (2) 代码部分
- Ext.data.Record
- [ERROR] InnoDB: Could not find a valid tablespace file
- redis渐入佳境(05) zset类型
- System.getProperty("user.dir")方法
- Ext.form.ComboBox 本地和远程模式的基本定义
- 【SVN】SVN设置日志提交限制和日志模板设置(windows下)
- C11新特性
- nyoj 2
- MFC的一些类
- iOS应用性能调优的25个建议和技巧