From: Heikki Tuuri (Heikki.Tuuriinnodb.com)
Date: Thu Jan 20 2005 - 17:58:20 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Marten,

----- Original Message -----
From: "Marten Lehmann" <lehmanncnm.de>
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 20, 2005 5:47 PM
Subject: 4.0.20 -> 4.1.9 Can't open file: 'Autor.ibd'

> Hello,
>
> some weeks ago we switched from mysql 4.0.20 to 4.18 and later to 4.1.9.
> A customer now told us, that he can't access his old InnoDB-tables. He
> gets
>
> #1016 - Can't open file: 'Autor.ibd' (errno: 1)
>
> if he tries to access the table "Autor". This happens to other
> InnoDB-tables created with mysql 4.0.20, too. The only file left is the
> Autor.frm. Have innodb-tables been stored in a central file at 4.0.20
> maybe and now individual table-files with 4.1.x? How can this happen?

I hope that you have not destroyed the ibdata file. The tables are there.
Did you edit the my.cnf in the upgrade? What does mysqld print to the .err
log?

> Regards
> Marten

Best regards,

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]