MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: MySQL complains about missing .ibd files that were never there
Posted by: Heikki Tuuri
Date: February 09, 2006 04:14AM

Alex,

the complaint about a missing .ibd file may also mean that the table does not exist in the ibdata files, though you do have the .frm file of the table.

MySQL uses a unified error message ("file .abc missing"), and unfortunately it is misleading in this case.

You should look into the .err log of mysqld for more information.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL complains about missing .ibd files that were never there
3722
Alex Cruise
February 08, 2006 06:21PM
Re: MySQL complains about missing .ibd files that were never there
4272
Heikki Tuuri
February 09, 2006 04:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.