2 messages in com.mysql.lists.mysqlRepairing InnoDB table
FromSent OnAttachments
Ville Mattila28 Apr 2004 03:27 
Victor Pendleton28 Apr 2004 04:49 
Subject:Repairing InnoDB table
From:Ville Mattila (vill@pilotmedia.fi)
Date:04/28/2004 03:27:46 AM
List:com.mysql.lists.mysql

Hello,

I have a database using a few InnoDB tables. The database has not been in use for a while and now I noticed that all InnoDB tables in the database cannot be opened and used at all. Whatever I try to do, I got "Can't open asiakkaat.InnoDB (errno: 1)" error. I'd like to know, how could I repair the tables and get even the structure copied.

I took a look to the data files and there are .frm files for the tables available.

Thank you for help,

Ville Mattila