I accidently deleted a number of data records (83 records) from a table
using  'delete' SQL command. I want to recover the deleted data. I
checked the table with  'myisamchk'. the result is as follows.

 

myisamchk seitext.MYI

Checking MyISAM file: seitext.MYI

Data records:       7   Deleted blocks:      86

myisamchk: warning: 2 clients 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

- check record links

 

MyISAM-table 'seitext.MYI' is usable but should be fixed

 

Is it possible to recover the deleted data ? How?

My mySQL is running on Redhat Linux and version 4.01.

 

min

Reply via email to