Can't open file ****.ibd (errno: 1)
Posted by:
jchua
Date: July 12, 2005 05:02PM
For the past 3 months, we have been running an application against a 4.1.8 InnoDB with about 2GB of data on a linux intel machine with 2GB RAM and plenty of hard drive space.
Now, for any query on all tables in the database, it results in the following error: Can't open file ****.ibd (errno: 1)
We are poking around using MySQL, MySQLAdmin, and have tried check table and repair table, have gotten no where. I have looked everywhere and can't find any documentation on this.
First, how can we overcome this error?
Second, how did this happen?
Any insight would be greatly appreciated.
Thanks, Jon.