InnoDB crash

[Mordek, Lennart]

Hallo zusammen,

Kann mir jemand bei folgendem Problem weiterhelfen? Eine Tabelle von meiner Datenbank ist defekt. Ich kann aus der Datei / Tabelle keine Daten mehr sichern. Ich bekomme trotz "innodb_force_recovery" nicht weiter :-( Hier noch die Ausgabe vom Log:

100322 14:39:24  InnoDB: error: space object of table test_wwtdb/gdata_history,
InnoDB: space id 1 did not exist in memory. Retrying an open.
100322 14:39:24  InnoDB: Error: tablespace id in file '.\test_wwtdb\gdata_history.ibd' is 555, but in the InnoDB
InnoDB: data dictionary it is 1.
InnoDB: Have you moved InnoDB .ibd files around without using the
InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.

100322 14:39:24  InnoDB: cannot calculate statistics for table test_wwtdb/gdata_history
InnoDB: because the .ibd file is missing.  For help, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
100322 14:39:24 [ERROR] MySQL is trying to open a table handle but the .ibd file for
table test_wwtdb/gdata_history does not exist.
Have you deleted the .ibd file from the database directory under
the MySQL datadir, or have you used DISCARD TABLESPACE?
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.

Danke.


Gruß
Lennart

- CONFIDENTIAL-

This email and any files transmitted with it are confidential, and may also be legally privileged.  If you are not the intended recipient, you may not review, use, copy, or distribute this message. If you receive this email in error, please notify the sender immediately by reply email and then delete this email.