By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,784 Members | 2,933 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,784 IT Pros & Developers. It's quick & easy.

Restore InnoDB data

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.