At 6:14 -0700 6/14/06, murthy gandikota wrote:
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent 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
Can anyone please help me figure this out?
Here are some pertinent facts:
a) stopped mysqld
b) copied files from sfg to sfgnew in the var directory
b) You can't do that with InnoDB tables. It records the directory
name in its internal data directory. You moved the tables, cause
their location to go out of sync with what InnoDB thinks.
You can probably solve this by moving the table files back. Then
use RENAME TABLE to rename them into a different database, or use
mysqldump to dump them and then reload them into a different database.
c) set the permissions to 777 (read, write, execute) for all the
files in sfgnew
d) restarted mysqld
Murthy
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
