From: Todd Lyons
Date: January 26 2012 2:50pm
Subject: Re: RES: RES: Force drop table
List-Archive: http://lists.mysql.com/mysql/226673
Message-Id: <CAFG21ojnbtLgCzkD2Tk--A3pTtMJj4YwhQ4VT7C7ED22G-gZzw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

2012/1/26 Suporte Avanutri <suporte2@stripped>:
>>>>>>>>[At this point I deleted the table =93obras.frm=94. Still trying to=
 dump, crashing every time, and restarting mysqld with a higher =93innodb_f=
orce_recovery=94 value at a time]

It doesn't matter what you set in innodb_force_recovery.  If you do
not have the obras.frm file (which contains the schema definition of
the table), I don't know if you can retrieve the info.  Put that file
back, start it with a value of 6, and see if you can get any of the
data out.

If the data is important and have a budget for recovery, you can try
(whatever solution is local for you) hiring a consultant skilled in
mysql crash data recovery:
- Oracle
- Percona
- SkySQL

Regards...            Todd
--=20
SOPA: Any attempt to [use legal means to] reverse technological
advances is doomed. =A0--Leo Leporte