Is the 'agent' table a current table, or one that got dropped at some point?
See
http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict.html
The last half seems relevant - it's pointing you to removing the .frm
file manually. Personally, I'd mv it and not rm it.
Dan
murthy gandikota wrote:
Hi Dan
I've set the permissions to 777 for all the files and directories.
Basically I did chmod -R 777 sfgnew. Also changed the ownership to mysql
using chown -R mysql:mysql sfgnew.
Thanks!
*/Dan Buettner <[EMAIL PROTECTED]>/* wrote:
Murthy, do you have appropriate permissions (777 works, or 775/770 if
owned by mysql user) on your new directory ('sfgnew')? If you don't
have execute permission for the mysql user on that dir, MySQL can't
list
the contents ...
Dan
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
> c) set the permissions to 777 (read, write, execute) for all the
files in sfgnew
> d) restarted mysqld
>
> Murthy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
