What are the permissions on the files? Which user runs mysql? If you're not on Windows, is the case the same? When you type "mysqld --print-defaults" (or whatever your mysql server binary is), what directory shows up under "datadir"? Is it the same directory?
Sincerely, Sheeri On 2/23/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote: > Hello. > > I get the following error when I try to query a table in a particular > database (test). The error is generated for all tables within that database. > However, 'mysql' database works fine. > > ERROR 1016 (HY000): Can't open file: 'TBL_FORUM_MSG_BODY.ibd' (errno: 1) > > However, I have noticed that both the .frm and the .ibd file exists for the > table TBL_FORUM_MSG_BODY. Then why the error? I looked into the error log > and it is as follows > > 060222 15:14:09 InnoDB error: > Cannot find table test/TBL_FORUM_MSG_BODY from the internal data dictionary > of InnoDB though the .frm file for the table exists. Maybe you > have deleted and recreated InnoDB data files but have forgotten > to delete the corresponding .frm files of InnoDB tables, or you > have moved .frm files to another database? > Look from section 15.1 of http://www.innodb.com/ibman.html > how you can resolve the problem. > 060222 15:14:09 [ERROR] /usr/sbin/mysqld: Can't open file: > 'TBL_FORUM_MSG_BODY.ibd' (errno: 1) > > > I tried restarting MySQL service in the hope that INNoDB will recognise the > files properly, but to no avail. Is there a way to find and correct what has > gone wrong? Someone please say 'yes'... > > I am on MySQL 4.1.11 with InnoDB as the storage engine and with per-table > tablespace. > > Regards, > Rithish. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]