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


Subject
Views
Written By
Posted
Can't open file ****.ibd (errno: 1)
11544
July 12, 2005 05:02PM
18598
November 04, 2005 10:27AM
3153
February 02, 2007 08:41AM
3819
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.