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

Reply via email to