karsites:/var/swissmade # ./myisamchk -dvv shop_item.MYI MyISAM file: shop_item.MYI Record format: Packed Character set: latin1_swedish_ci (8) File-version: 1 Creation time: 2006-03-31 13:59:48 Status: open,changed Auto increment key: 1 Last value: 673 Data records: 0 Deleted blocks: 675 Datafile parts: 675 Deleted data: 33760 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 Datafile length: 33760 Keyfile length: 8192 Max datafile length: 4294967294 Max keyfile length: 4398046510079 Recordlength: 295
It looks like someone has packed this table with myisampack, which means it's read only. Did you use myisampack on the table before it got dropped Nico? Also, did mysql die when the table was in use? I have tries to run myisamchk -r shop_item.MYI but this sets the *.MYD file to zero. I don't know if it is possible to recover data from a packed table. AFAIK the packing process is one way, and you may need the original non-compressed table to get your data. Regards Keith On Mon, 3 Apr 2006, Nico Schefer wrote: > To: [EMAIL PROTECTED] > From: Nico Schefer <[EMAIL PROTECTED]> > Subject: Re: Undelete rows with .MYD-File? > > Hi > > Keith, thanks for your proposal with myisamchk. > > If i'm using the myisamchk, it finds the deleted rows, but i have not > found a way to restore them and i can't find nothing in the manual.. > > Checking MyISAM file: shop_item.MYI > Data records: 0 Deleted blocks: 675 > myisamchk.exe: 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 > - check record links > MyISAM-table 'shop_item.MYI' is usable but should be fixed > > Does anybody know how to restore the data this way? > > Thanks a lot, Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
