MySQL Forums
Forum List  »  InnoDB

MySQL complains about missing .ibd files that were never there
Posted by: Alex Cruise
Date: February 08, 2006 06:21PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL complains about missing .ibd files that were never there
3719
February 08, 2006 06:21PM


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.