MySQL complains about missing .ibd files that were never there

[Alex Cruise]

Hi there,

I'm unable to use one of my databases. Every time I try to access an InnoDB table, MySQL complains about a missing .ibd file. But my database has never had .ibd files, it's always been contained within one big /var/lib/mysql/ibdata.

This server is running FC4's recently-updated mysql-server-4.0.16 package.

My my.cnf is as follows:

[mysqld]
# The default character set is utf8
default-character-set=utf8
character-set-server=utf8

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
bulk_insert_buffer_size=0
innodb_data_file_path=ibdata:1024M:autoextend
innodb_additional_mem_pool_size=2M
innodb_log_buffer_size=1M
innodb_buffer_pool_size=64M
# only need this buffer for the
# mysql tablespace for authentication
key_buffer_size=512K
query_cache_size=32M
query_cache_limit=8M
innodb_log_file_size=16M
# This makes it flush to the doublewrite file
# but not the main file on commit
# should be safe and fast.
# doublewrite will recover after fail
innodb_flush_log_at_trx_commit=2
max_connections=512
low-priority-updates=0
transaction-isolation=READ-COMMITTED
max_connect_errors=2000000
# memlock=1 will lock mysql into ram
# memory use with the current structure should be
# A bit over approximately 64 + 2 + 8 + 32 = 106 Mb
# on real machine: 122Mb. on 64 bit: 207mb
memlock=0
interactive_timeout=864000

[mysql.server]
bind-address=0.0.0.0
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid