I'm getting the following error in mysql server 5.6 upon startup. the below mentioned table disappeared, but both .ibd and .frm file does exist, has the right permissions and is owned by mysql user and group. I use one file per innodb db table. what's wrong?
2013-11-22 15:20:35 12922 [ERROR] InnoDB: Could not find a valid tablespace file for 'mydb/mytable'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2013-11-22 15:20:35 12922 [ERROR] InnoDB: Tablespace open failed for '"mydb"."mytable"', ignored. 2013-11-22 15:20:35 7fa5d2a0f720 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.