Hi Micheal
Thanks for your suggestions. I use mysqldump to restore the DB's. Apparently
mysqldump doesn't create forward declarations for views. So I had to manually
feed the views in correct order to avoid errors. Also to import the DB sfg into
sfgnew I had to substitute all of the `sfg` patt
murthy gandikota wrote:
> 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
Dan Buettner wrote:
> Murthy, do you have
Murthy, if you want to dump database A and restore into database B, it's
basically a 3-step process. You have to first create B, then dump A,
then pipe the dump of A into B. Using the --no-data option with
mysqldump will dump only structure, no data.
something like this:
mysql -u root -psec
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
*mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 8:12 AM
To: murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
Murthy, doing some quick reading on InnoDB table definitions, it appears
that MySQL itself keeps s
ing similar to recreate your tables and move them. HTH.
-phpninja
-Original Message-
From: Dan Buettner
[*mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 8:12 AM
To: murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent
murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
Murthy, doing some quick reading on InnoDB table definitions, it appears
that MySQL itself keeps some info in the .frm file, while InnoDB keeps some
info within the table
u 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
(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:
> >
> >
rote:
>
> 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
(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
> ER
tting 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. May
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
13 matches
Mail list logo