I have tried giving 777 permissions on the files. Nothing happens. All mysql processes run as 'mysql' except mysqld-safe, runs as root.
I am not on Windows. All the table names are in upper case. I don't have the lower case setting in my.cnf also. The 'datadir' is /var/lib/mysql/ This is where the mysql is located. That's proper. -----Original Message----- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, February 24, 2006 3:22 AM To: Rithish Saralaya Cc: MySQL general mailing list Subject: Re: error 1016 : cant open ibd file even though it exists 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]
