MySQL Forums
Forum List  »  MyISAM

Repair problem
Posted by: arena.alberto
Date: August 29, 2005 08:43AM

Hello all

Due to power problem, 5 tables of a MyISAM database crashed and corrupted. We were able to recover 3 of them using a backup copy, but not the last 2 ones, because backup was not updated and overwriting them we would lose recent data.

We made immediately a safe copy of the 2 corrupted tables, and consulting MySql documentation, tried to recover them. But we couldn't overcome:

---------------------------------------------------------------

1) the first table is of 150mb, and myisamchk founds a wrong record at 101449648 position: it means, it can recover only for about 96,7 mB (losing a lot of records). We tried all myisamchk options, but result is the same: we lose about 50mb of data.

Checking MyISAM file: ric200503
Data records: 0 Deleted blocks: 0
\mysql\bin\myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size
\mysql\bin\myisamchk: warning: Size of indexfile is: 17728512 Should be: 2048
\mysql\bin\myisamchk: warning: Size of datafile is: 161182084 Should be: 0
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
\mysql\bin\myisamchk: error: Found wrong record at 101449648
MyISAM-table 'ric200503' is corrupted
Fix it using switch "-r" or "-o"

---------------------------------------------------------------

2) the other table gives the following error:
\mysql\bin\myisamchk: error: 'ric200504' doesn't have a correct index definition . You need to recreate it before you can do a repair

We also tried to recreate the table definition (by means of TRUNCATE TABLE) and copy data file, but with no success

---------------------------------------------------------------

Any suggestions about how to cope with? We need absolutely to find a solution, because these data are very important

Thanks in advance

Best regards,
Alberto

Options: ReplyQuote


Subject
Views
Written By
Posted
Repair problem
4401
August 29, 2005 08:43AM
2136
August 30, 2005 01:03AM
2037
August 30, 2005 02:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.