Can't open file: 'the_table.ibd' (errno: 1)

[arianhojat]

This table has not been openable for months, I try doing a SELECT * FROM the_table and get an error that

"Can't open file: 'the_table.ibd' (errno: 1)" not sure what to do. ill be fine with deleting it, and rebuilding it. trying to but delete it gives me a "MYSQL 1051 ERROR, unknown table 'the_table'", however it still shows up in my MYSQL Query Browser screen. Cant do a CREATE either, says table already exists haha.

 

I googled around for months off and on, maybe has something to do with deleting certain files in the database .frm or .ibd values maybe? Finally need to use that table again, so hence why i delayed looking into it for so long.

[fenway]

Does CHECK TABLES give the same thing? Are you using a single tablespace?

[arianhojat]

Hey fenway,

When i run that on respected table, i get:

| Table                  | Op    | Msg_type | Msg_text                                        |

+------------------------+-------+----------+-------------------------------------------------+

| thedatabase.thetablename | check | error    | Can't open file: 'thetablename.ibd' (errno: 1) |

 

any ideas? i am on Windows Box, and MYSQL 4.1.12a-nt

[fenway]

You've tried this and this already?