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
