Recovery of Lost or Corrupted InnoDB Tables

Aleksandr Kuzminsky (Percona Inc)
Average rating: ****.
(4.00, 3 ratings)

When an InnoDB table is deleted physically its records remain untouched some time. Knowing how InnoDB stores information and the table’s structure it is possible to recover the records.

The session covers topics:

  • InnoDB page format
  • Internal system tables SYS_INDEXES and SYS_TABLES
  • InnoDB Primary and Secondary keys
  • Typical failure scenarios
  • Dealing with corrupted InnoDB tablespace
  • Recovery from a raw partition

The session is illustrated with examples using Percona in-house InnoDB Recovery Tool.

Aleksandr Kuzminsky

Percona Inc

Aleksandr Kuzminsky is a colsultant of Percona Inc since 2008. His primary focus is emergency data recovery from corrupted databases.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.