Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.
share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.