List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:June 1 1999 6:42pm
Subject:Re: recovery after delete
View as plain text  
>>>>> "KB" == Keki Balazs <keki@stripped> writes:

If you have the exact same "CREATE TABLE" statement for that table,
then yes.

1) do the create table.
2) shutdown mysql.  move the ISD file in place over the old one
3) run "isamchk -r" on it

That should do it.

KB> Hi,
KB> I have accidentally deleted a table (made a delete from table), but 
KB> successfully saved the files from /var/lib/mysql containing the table's 
KB> data (.ISM, .ISD)
KB> I tried to recover the deleted rows with isamchk, which finds the ~375000 
KB> deleted rows int he files, but does not recover it, only finishes the 
KB> deletion, leaving no rows in the table.
KB> Is there a way to recover the data stored in these files?

KB> keki


KB> ---------------------------------------------------------------------
KB> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
KB> posting. To request this thread, e-mail mysql-thread4299@stripped

KB> To unsubscribe, send a message to the address shown in the
KB> List-Unsubscribe header of this message. If you cannot see it,
KB> e-mail mysql-unsubscribe@stripped instead.

Thread
MySQL sub-queries..Pat Trainor28 May
  • recovery after deleteKeki Balazs1 Jun
    • Re: recovery after deleteVivek Khera1 Jun
    • recovery after deleteMichael Widenius3 Jun