469,579 Members | 1,102 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Problems with innoDB files

I am a novice user of MySQL so please excuse my ignorance.

I recently installed MySQL and have a third party tool using it to
update data in a database.

Recently it started creating erorr messages:

table.innoDB missing

Looking at the database in phpMyAdmin the table affected is marked as
in use. Trying to get in reports the error again.

This problem seems to have only affected 2 out of the three 3 tables.
I have tried flushing the tables, restarting mysql, dropping the
tables, restarting the computer and restoring from a backup and I
still keep getting the same errors.

I also did a search of my hard disk and found not one single *.innoDB
file, so I suspect I am missing something fundamental.

Can anyone help me, I am rather confused?

Thanks.
Jul 19 '05 #1
3 3936
Martin,

"Martin Gill" <ma*********@hotmail.com> kirjoitti viestissä
news:38**************************@posting.google.c om...
I am a novice user of MySQL so please excuse my ignorance.

I recently installed MySQL and have a third party tool using it to
update data in a database.

Recently it started creating erorr messages:

table.innoDB missing
please look in the .err log of mysqld.

You probably have the .frm files of the tables left, but have recreated the
ibdata file(s), so that the actual tables inside InnoDB do not exist any
more. If that is the case, you can just delete the .frm files of those
tables.
Looking at the database in phpMyAdmin the table affected is marked as
in use. Trying to get in reports the error again.

This problem seems to have only affected 2 out of the three 3 tables.
I have tried flushing the tables, restarting mysql, dropping the
tables, restarting the computer and restoring from a backup and I
still keep getting the same errors.

I also did a search of my hard disk and found not one single *.innoDB
file, so I suspect I am missing something fundamental.

Can anyone help me, I am rather confused?

Thanks.


Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables

Order MySQL technical support from https://order.mysql.com/
Jul 19 '05 #2
Martin,

"Martin Gill" <ma*********@hotmail.com> kirjoitti viestissä
news:38**************************@posting.google.c om...
I am a novice user of MySQL so please excuse my ignorance.

I recently installed MySQL and have a third party tool using it to
update data in a database.

Recently it started creating erorr messages:

table.innoDB missing
please look in the .err log of mysqld.

You probably have the .frm files of the tables left, but have recreated the
ibdata file(s), so that the actual tables inside InnoDB do not exist any
more. If that is the case, you can just delete the .frm files of those
tables.
Looking at the database in phpMyAdmin the table affected is marked as
in use. Trying to get in reports the error again.

This problem seems to have only affected 2 out of the three 3 tables.
I have tried flushing the tables, restarting mysql, dropping the
tables, restarting the computer and restoring from a backup and I
still keep getting the same errors.

I also did a search of my hard disk and found not one single *.innoDB
file, so I suspect I am missing something fundamental.

Can anyone help me, I am rather confused?

Thanks.


Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables

Order MySQL technical support from https://order.mysql.com/
Jul 19 '05 #3
Martin,

"Martin Gill" <ma*********@hotmail.com> kirjoitti viestissä
news:38**************************@posting.google.c om...
I am a novice user of MySQL so please excuse my ignorance.

I recently installed MySQL and have a third party tool using it to
update data in a database.

Recently it started creating erorr messages:

table.innoDB missing
please look in the .err log of mysqld.

You probably have the .frm files of the tables left, but have recreated the
ibdata file(s), so that the actual tables inside InnoDB do not exist any
more. If that is the case, you can just delete the .frm files of those
tables.
Looking at the database in phpMyAdmin the table affected is marked as
in use. Trying to get in reports the error again.

This problem seems to have only affected 2 out of the three 3 tables.
I have tried flushing the tables, restarting mysql, dropping the
tables, restarting the computer and restoring from a backup and I
still keep getting the same errors.

I also did a search of my hard disk and found not one single *.innoDB
file, so I suspect I am missing something fundamental.

Can anyone help me, I am rather confused?

Thanks.


Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables

Order MySQL technical support from https://order.mysql.com/
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by sean peters | last post: by
reply views Thread by Lazy70 | last post: by
reply views Thread by Martin Gill | last post: by
3 posts views Thread by Reuben Pearse | last post: by
1 post views Thread by fuzzybr80 | last post: by
1 post views Thread by PowerLifter1450 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.