[ERROR] InnoDB: Could not find a valid tablespace file

mysql启动报下述错误：
[ERROR] InnoDB: Could not find a valid tablespace file for 'test/sys_log'. See http://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.