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. Link to comment https://forums.phpfreaks.com/topic/106674-cant-open-file-the_tableibd-errno-1/ 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? Link to comment https://forums.phpfreaks.com/topic/106674-cant-open-file-the_tableibd-errno-1/#findComment-547390 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 Link to comment https://forums.phpfreaks.com/topic/106674-cant-open-file-the_tableibd-errno-1/#findComment-547416 Share on other sites More sharing options...
fenway Posted May 23, 2008 Share Posted May 23, 2008 You've tried this and this already? Link to comment https://forums.phpfreaks.com/topic/106674-cant-open-file-the_tableibd-errno-1/#findComment-548152 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.