MySQL Table Repair Warning

MySQL, PostgreSQL, SQLite
moppi
Posts: 368
Joined: 2003-02-15 11:16

MySQL Table Repair Warning

Post by moppi » 2003-06-27 08:59

Hallo ich habe ein kleines Problem mit MyISAM Tables.
Wenn ich folgendes ausführe erhalte ich die schwerwiegenden Fehlermeldungen.

Code: Select all

REPAIR TABLE `...`, `...` USE FRM;
Wie kann ich veranlassen, das diese FRM Dateien neu eingespielt werden.
Das Problem besteht seit einem Datenbank-Restore.

Gruß
Daniel

jtb
Posts: 599
Joined: 2002-08-18 16:41
Location: Darmstadt

Re: MySQL Table Repair Warning

Post by jtb » 2003-06-27 11:26

Wie sehen die Fehlermeldungen denn aus?

moppi
Posts: 368
Joined: 2003-02-15 11:16

Re: MySQL Table Repair Warning

Post by moppi » 2003-06-27 11:34

Code: Select all

+-------------------------------+--------+----------+----------------------------------------+
| Table                         | Op     | Msg_type | Msg_text                               |
+-------------------------------+--------+----------+----------------------------------------+
| usr_web2_1.active_sessions    | repair | warning  | Number of rows changed from 0 to 19    |
| usr_web2_1.active_sessions    | repair | status   | OK                                     |
| usr_web2_1.auth_user          | repair | warning  | Number of rows changed from 0 to 17    |
| usr_web2_1.auth_user          | repair | status   | OK                                     |
| usr_web2_1.bankleitzahlen     | repair | warning  | Number of rows changed from 0 to 22147 |
| usr_web2_1.bankleitzahlen     | repair | status   | OK                                     |
| usr_web2_1.bestellanschrift   | repair | status   | OK                                     |
| usr_web2_1.bestelldaten       | repair | status   | OK                                     |
| usr_web2_1.dienstleistungen   | repair | warning  | Number of rows changed from 0 to 10    |
| usr_web2_1.dienstleistungen   | repair | status   | OK                                     |
| usr_web2_1.dns_records        | repair | warning  | Number of rows changed from 0 to 17    |
| usr_web2_1.dns_records        | repair | status   | OK                                     |
| usr_web2_1.domains            | repair | warning  | Number of rows changed from 0 to 17    |
| usr_web2_1.domains            | repair | status   | OK                                     |
| usr_web2_1.faelligkeiten      | repair | warning  | Number of rows changed from 0 to 23    |
| usr_web2_1.faelligkeiten      | repair | status   | OK                                     |
| usr_web2_1.feedback           | repair | warning  | Number of rows changed from 0 to 2     |
| usr_web2_1.feedback           | repair | status   | OK                                     |
| usr_web2_1.kunden             | repair | warning  | Number of rows changed from 0 to 17    |
| usr_web2_1.kunden             | repair | status   | OK                                     |
| usr_web2_1.kundenkonto        | repair | warning  | Number of rows changed from 0 to 7     |
| usr_web2_1.kundenkonto        | repair | status   | OK                                     |
| usr_web2_1.kundenumsaetze     | repair | warning  | Number of rows changed from 0 to 4     |
| usr_web2_1.kundenumsaetze     | repair | status   | OK                                     |
| usr_web2_1.meine_daten        | repair | warning  | Number of rows changed from 0 to 1     |
| usr_web2_1.meine_daten        | repair | status   | OK                                     |
| usr_web2_1.postleitzahlen     | repair | warning  | Number of rows changed from 0 to 44188 |
| usr_web2_1.postleitzahlen     | repair | status   | OK                                     |
| usr_web2_1.rechnungsanschrift | repair | warning  | Number of rows changed from 0 to 7     |
| usr_web2_1.rechnungsanschrift | repair | status   | OK                                     |
| usr_web2_1.rechnungsdaten     | repair | warning  | Number of rows changed from 0 to 9     |
| usr_web2_1.rechnungsdaten     | repair | status   | OK                                     |
| usr_web2_1.warenkorb          | repair | status   | OK                                     |
+-------------------------------+--------+----------+----------------------------------------+
33 rows in set (3.60 sec)

[monk]
Posts: 163
Joined: 2002-08-09 17:31
Location: Ulm

Re: MySQL Table Repair Warning

Post by [monk] » 2003-06-27 16:11

hi moppi. Ich hab hier nen Interresanten Link für dich:

http://www.bttr.org/mysql/doc/man/manua ... aintenance

moppi
Posts: 368
Joined: 2003-02-15 11:16

Re: MySQL Table Repair Warning

Post by moppi » 2003-06-27 16:32

Also ich habe die Tables mit myisamchk geprüft. kein Reusltat.

ich habe die Tabellen neu importiert. Die Fehlermeldung bleibt.

Was nun </MONK> ??