arianhojat Posted May 21, 2008 Share Posted May 21, 2008 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted May 22, 2008 Share Posted May 22, 2008 Does CHECK TABLES give the same thing? Are you using a single tablespace? Quote Link to comment Share on other sites More sharing options...
arianhojat Posted May 22, 2008 Author Share Posted May 22, 2008 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted May 23, 2008 Share Posted May 23, 2008 You've tried this and this already? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.