List:General Discussion« Previous MessageNext Message »
From:Todd Lyons Date:January 26 2012 2:50pm
Subject:Re: RES: RES: Force drop table
View as plain text  
2012/1/26 Suporte Avanutri <suporte2@stripped>:
>>>>>>>>[At this point I deleted the table
> “obras.frm”. Still trying to dump, crashing every time, and restarting mysqld
> with a higher “innodb_force_recovery” 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
-- 
SOPA: Any attempt to [use legal means to] reverse technological
advances is doomed.  --Leo Leporte
Thread
Force drop tableSuporte Avanutri24 Jan
  • RE: Force drop tableShafi AHMED24 Jan
  • RES: Force drop tableSuporte Avanutri24 Jan
    • Re: RES: Force drop tableJohan De Meersman24 Jan
      • RES: RES: Force drop tableSuporte Avanutri24 Jan
        • Re: RES: Force drop tableSuresh Kuna25 Jan
          • RES: RES: Force drop tableSuporte Avanutri25 Jan
            • Re: RES: RES: Force drop tableJohan De Meersman25 Jan
              • RES: RES: RES: Force drop tableSuporte Avanutri26 Jan
                • Re: RES: RES: Force drop tableTodd Lyons26 Jan
                  • Re: RES: RES: Force drop tableJohan De Meersman26 Jan
                    • RES: RES: RES: Force drop tableSuporte Avanutri26 Jan
        • Re: RES: Force drop tableTodd Lyons25 Jan
          • Re: RES: Force drop tableTodd Lyons25 Jan