On Thu, Apr 20, 2000 at 09:58:11AM -0400, Graeme B. Davis wrote:
> Is there a way I can recover a table that still has all of the data in it,
> but the records are deleted? myisamchk says this:
Take a backup of the table first, before you start messing with it.
If they're fixed-length records, you should be able to recover most
of it. MySQL marks a record as deleted by changing the first byte
to 0. Just change it to something other than 0 for each record, and
then run isamchk on the table. I've never done it personally, but
it should work....
> Checking MyISAM file: mails.MYI
> Data records: 0 Deleted blocks: 153
> - check file-size
> - check key delete-chain
> - check record delete-chain
> - check index reference
> - check data record references index: 1
> - check record links
> I'm hoping I can get those 153 back :(
> Any suggestions
Tim Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.