>>>>> "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.
