Fejl i en enkelt tabel

Løsning:

Please try to do a \'isamchk table_name\' on the table. If there are any errors, you can correct this with \'isamchk -r table_name\' (note, no \'-q\' !)

Please ensure that no one is using your tables while you run isamchk -r

/per

Husk:

Do you have to ensure that no one is using your tables even if you\'re using locking?  The -w argument to isamchk implies that you don\'t have to worry about other use of the tables.

/per

hmm, skummelt. Prøv at brug Repair Table

REPAIR TABLE tbl_name[,tbl_name...] [QUICK] [EXTENDED]

If QUICK is given then MySQL will try to do a REPAIR of only the index tree.

If you use EXTENDED then MySQL will create the index row by row instead of creating one index at a time with sorting; This may be better than sorting on fixed-length keys if you have long char() keys that compress very good.



Desuden skulle du prøve at se:http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#REPAIR_TABLE

Det er ikke skummelt, for samchk -r table_name er nøjagtig det samme ifølge dit link.

/per

Det hedder bare myisamchk -r table_name i dit link.

/per

Jeg mente fejlen han fik var skummel

Desuden henviser jeg bare til mySQL dokumentationen

Tja, no matter what, så virkede det. Takker mange gange!