Re: Hilfe alle Daten gelöscht

[Martin Ramsch <m.ramsch_(at)_computer.org>]

Johannes Arlt schrieb am Freitag, den  1. Oktober 1999:
> ich habe ausversehen ein falsches SQL statement benutzt, jedenfalls war
> mysql der Meinung ich benötige ALLE Datensätze nicht mehr, was irre ist.
> Kann man das rückgängig machen wenn, ja wie, sonst ist hier alles weg.
> In der Datei tabellen_name.ISD sind die Eintäge alle noch da. Es muß
> doch eigentlichen einen Weg geben.

Du bist schon der dritte heute ... (internationale Liste inklusive).

Anbei, was Monty schrieb.

Viel Glück!

Ciao,
  Martin
-- 
Martin Ramsch <m.ramsch_(at)_computer.org> <URL: http://ramsch.home.pages.de/ >
PGP: 0xE8EF4F75, 5244 5EF3 B0B1 3826  E4EC 8058 7B31 3AD7

---- Begin included message ----

• Subject: Undelete in base?
• From: Michael Widenius <monty_(at)_analytik.analytikerna.se>
• Date: Thu, 30 Sep 1999 21:59:21 +0200 (MET DST)
• Cc: mysql_(at)_lists.mysql.com
• Content-Length: 1897
• Content-Transfer-Encoding: 7bit
• Delivered-To: mailing list mysql_(at)_lists.mysql.com
• In-Reply-To: <14322.17605.305061.579852_(at)_shuttle.svib.ru>
• List-Help: <mailto:mysql-help_(at)_lists.mysql.com>
• List-Post: <mailto:mysql_(at)_lists.mysql.com>
• List-Subscribe: <mailto:mysql-subscribe_(at)_lists.mysql.com>
• List-Unsubscribe: <mailto:mysql-unsubscribe-ramsch=forwiss.uni-passau.de_(at)_lists.mysql.com>
• Mailing-List: contact mysql-help_(at)_lists.mysql.com; run by ezmlm (http://www.ezmlm.org)
• References: <14322.17605.305061.579852_(at)_shuttle.svib.ru>
• Reply-To: monty_(at)_analytikerna.se

>>>>> "Alex" == Alex Povolotsky <tarkhil_(at)_asteroid.svib.ru> writes:

Alex> Hello!
Alex> I have accidently deleted nearly all of my base (using delete from
Alex> users where uid-460 instead of uid=460). As far as I have seen
Alex> database files, (nearly) all data are still in there; I do not have a
Alex> recent backup (yes shame on me. lotsa).

Alex> Is there any way to recover as much data as possible from the table?

Alex> I'm in GREAT time-pressure, and I thanks in advance for ANY usable
Alex> help. I do not want to end up making an utility to parse database file 
Alex> from scratch.

Hi!

Do you have a MySQL log or a update log ?  You can check this by doing 
'mysqladmin variables' ?  If yes, you can probably reconstruct your data from
the logs!

Start by taking a copy of your table!

You may be able to reconstruct part of your table if this is in fixed
row format.  Try doing 'isamchk -dv' on the table.

If isamchk reports the table to be of 'fixed' size, you may be able to 
recover parts of it by writing a short C program that puts a '255' on
the first byte of each row! (isamchk reports the row size).  After
this you will get back some of your data by doing 'isamchk -rq -k0
table_name'.

Note however that in any case you will not get back the first 5 bytes
of each row (the delete link has destroyed this information).  You may 
however be able to do some program to recovers at least some of your
data.

If the table type is 'dynamic' things are much worse...

Regards,
Monty





---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread14817_(at)_lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe_(at)_lists.mysql.com instead.

---- End included message ----