Skip navigation links

MySQL Forums :: InnoDB :: Can't open file ****.ibd (errno: 1)


Advanced Search

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) 9899 jchua 07/12/2005 05:02PM
Re: Can't open file ****.ibd (errno: 1) 3977 Marko Mäkelä 07/14/2005 05:09AM
Re: Can't open file ****.ibd (errno: 1) 3862 Americo Vanderlei 08/26/2005 11:07AM
Re: Can't open file ****.ibd (errno: 1) 4069 Maria Modeste 08/27/2005 11:48AM
Re: Can't open file ****.ibd (errno: 1) 3529 Marko Mäkelä 09/08/2005 12:42AM
Re: Can't open file ****.ibd (errno: 1) 4364 Michael Morrissey 10/18/2005 08:31PM
Re: Can't open file ****.ibd (errno: 1) 2950 Chris Bloom 10/19/2005 10:46AM
Re: Can't open file ****.ibd (errno: 1) 2767 Jos Juffermans 10/24/2005 01:42AM
Re: Can't open file ****.ibd (errno: 1) 3134 Christopher TruLove 11/04/2005 03:11AM
Re: Can't open file ****.ibd (errno: 1) 3250 Ionut Petre 10/19/2007 01:25AM
Re: Can't open file ****.ibd (errno: 1) 2999 Heikki Tuuri 10/19/2005 11:19AM
Re: Can't open file ****.ibd (errno: 1) 3045 Heikki Tuuri 10/25/2005 11:33AM
Re: Can't open file ****.ibd (errno: 1) 15838 Heikki Tuuri 11/04/2005 10:27AM
Re: Can't open file ****.ibd (errno: 1) 2691 vijay kadadi 02/02/2007 08:41AM
Re: Can't open file ****.ibd (errno: 1) 3164 anci wasim 01/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.