Re: Problem after DELETE

[consystor]

Yes. And if I run 'myisamchk -r weatherdata' then it deletes all "Deleted blocks", so myisamchk can manipulate the files but 'myisamchk --extended-check weatherdata' does nothing...

But I've also tried the following command to get rid of the warning message "1 client is using or hasn't closed...":

$ myisamchk -f weatherdata
Checking MyISAM file: weatherdata
Data records: 0 Deleted blocks: 839435
myisamchk: warning: 1 client is using or hasn't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1

$ myisamchk -e weatherdata
Checking MyISAM file: weatherdata
Data records: 0 Deleted blocks: 839435
- 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

But it does nothing...