myisamchk 를 해보았습니다.
Checking MyISAM file: tbl_question
Data records: 0 Deleted blocks: 71
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check records and index references
위와같은 결과가 나왔는데요..
제가볼땐
Deleted blocks: 71
요부분이 문제인듯합니다.. 실제로 해당 테이블에는 71개정도의 데이터가 존재했었거든요
위의 Deleted blocks 를 복구할수 있는 방법이 있을까요?
부탁드립니다.
** 참고로 복구하려하면 아래와같은 에러가 납니다.
- recovering (with sort) MyISAM-table 'tbl_question'
Data records: 0
- Fixing index 1
Delete link points outside datafile at 0
Found block with too small length at 2652; Skipped
Found block with too small length at 3788; Skipped
Found block that points outside data file at 13672
Found block that points outside data file at 14024
Found block that points outside data file at 14108
Found block that points outside data file at 14660
Found block that points outside data file at 17188
Found block that points outside data file at 17192
Found block that points outside data file at 27952
Found block that points outside data file at 27976
Found block that points outside data file at 28064
Found block that points outside data file at 28620
Found block that points outside data file at 28980
Found block that points outside data file at 28984
Found block that points outside data file at 29144
Found block that points outside data file at 29148
Found block that points outside data file at 29896
Found block that points outside data file at 30272
Found block that points outside data file at 30288
Found block that points outside data file at 30680
Found block that points outside data file at 32344
Found block that points outside data file at 32784
Found block that points outside data file at 33832
Found block that points outside data file at 33848
대체 머가 이상한건지.. 아래의 여러 비슷한 상황에서의 대처를 해보았지만 모두 안되네요.ㅜㅜ
|