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?
On 2/23/06, Rithish Saralaya <rithish.saralaya@stripped> wrote:
> 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