MySQL Forums
Forum List  »  InnoDB

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.

Options: ReplyQuote

Written By
Can't open file ****.ibd (errno: 1)
July 12, 2005 05:02PM
November 04, 2005 10:27AM
February 02, 2007 08:41AM
January 08, 2008 04:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.