Re: Can't open file ****.ibd (errno: 1)
jchua wrote:
> 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.