469,917 Members | 1,873 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

Restore InnoDB data

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
Jul 19 '05 #1
2 11835
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

Jul 19 '05 #2
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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Asif Iqbal | last post: by
reply views Thread by Lazy70 | last post: by
reply views Thread by Kurt Tragant | last post: by
3 posts views Thread by Reuben Pearse | last post: by
4 posts views Thread by Hardy | last post: by
reply views Thread by aangeliceus | last post: by
5 posts views Thread by chow.justy | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.