Hi, I crash one table, and some datas are completely corrupted. However, myisamchk doesn't seem to see any errors (I try -e, -o and -r option)... Here is an extract of the table : mysql> SELECT * FROM forumconthardwarefr6 order by date desc limit 0,20; +----------------------------------------------------------------------------------+---------------------+--------+---------------------+-------------------------------------+-------+-------+---------------------+---------+-------------------------------------+---------+ | titre | |numeropost | ouvert | date | auteur | | icone | nbrep | maxnumrep | vue | lastauteur | | sondage | +----------------------------------------------------------------------------------+---------------------+--------+---------------------+-------------------------------------+-------+-------+---------------------+---------+-------------------------------------+---------+ | Vds Barette EDO pour moins j | |8387233509356368993 | 0 | /-/-0--)0 26:25:28 | ssonneur_de_vie | | 117 | 0 | 7238777759610131712 | 27016 | | | 10 | | artitionz | |7300902383298871296 | 100 | J521-99-51 55:87:56 | hork | | 108 | 0 | 8289623147154535528 | 7696240 | fman | | 118 | | city | |8320800813073630040 | 117 | p706-83-13 97:69:41 | inary Finary | | 108 | 105 | 8241943594372651008 | 5138548 | et | | 0 | | et | |661841128741497964 | 7 | Å.()-*(-+. 79:64:86 | | | 101 | 0 | 270336 | 24 | AZIZDELAZUP | | 0 | <cut> The date column is DATETIME, and as you can see, the datas are completely corrupted, but myisamchk doesn't see anything wrong :( Do you have any idea how I can recover the table ? Thanks a lot ! Jocelyn Fournier Presence-PC
HELP ! Myisamchk doesn't seem to see error in my table :(
Fournier Jocelyn [Presence-PC] Sat, 14 Jul 2001 08:02:29 -0700
- Re: HELP ! Myisamchk doesn't seem to see er... Fournier Jocelyn [Presence-PC]
- Re: HELP ! Myisamchk doesn't seem to s... Tonu Samuel