Restore InnoDB data

[Lazy70]

Hi to everyone,

Ihave a hard problem to resolve.

In my Mysql database there is sometihng that doesn't work.
With MySQLFront I have all my InnoDB tables with this comment:
"Can't open file: 'certificatetype.InnnoDB'. (errno: 1)"

and in my loog files I read:

031215 15:33:53 InnoDB error:
Cannot find table test/certificatetype 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.

I have read the 15.1 section and I try to delete .frm files, but I can
not be able to see all the tables :(

Any body have some tip?

Thank you
Ktrl+S

[Heikki Tuuri]

Please look at my reply from http://lists.mysql.com/list.php?list=win32#b

"Lazy70" <s.**********@katamail.com> kirjoitti viestissä
news:d0**************************@posting.google.c om...

Hi to everyone,

Ihave a hard problem to resolve.

In my Mysql database there is sometihng that doesn't work.
With MySQLFront I have all my InnoDB tables with this comment:
"Can't open file: 'certificatetype.InnnoDB'. (errno: 1)"

and in my loog files I read:

031215 15:33:53 InnoDB error:
Cannot find table test/certificatetype 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.

I have read the 15.1 section and I try to delete .frm files, but I can
not be able to see all the tables :(

Any body have some tip?

Thank you
Ktrl+S

[Heikki Tuuri]

Please look at my reply from http://lists.mysql.com/list.php?list=win32#b

"Lazy70" <s.**********@katamail.com> kirjoitti viestissä
news:d0**************************@posting.google.c om...

Hi to everyone,

Ihave a hard problem to resolve.

In my Mysql database there is sometihng that doesn't work.
With MySQLFront I have all my InnoDB tables with this comment:
"Can't open file: 'certificatetype.InnnoDB'. (errno: 1)"

and in my loog files I read:

031215 15:33:53 InnoDB error:
Cannot find table test/certificatetype 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.

I have read the 15.1 section and I try to delete .frm files, but I can
not be able to see all the tables :(

Any body have some tip?

Thank you
Ktrl+S