MySQL Forums
Forum List  »  Data Recovery

Re: InnoDB corrupted by ransomware attack
Posted by: Aleksandr Kuzminsky
Date: July 04, 2018 11:32AM

Felix Wan Wrote:
-------------------------------------------------------
> the bad news is
> ibdata1 file also having some problem..


What problems does ibdata1 have? To recover tables structure you need only InnoDB dictionary which resides in the beginning of ibdata1. So, maybe it's not all bad.

> does that mean I can just guess the structure and
> indexes of that table
> and once I got the correct structure, I can then
> get all data back?

It's possible to guess structure fields and field types from .ibd but you have to be very-very-very familiar with InnoDB page format. Here are few links to start with:
https://blog.jcole.us/2013/01/10/the-physical-structure-of-records-in-innodb/
https://dev.mysql.com/doc/refman/8.0/en/innodb-physical-record.html
https://www.slideshare.net/akuzminsky/undrop-for-innodb-47122998 (slide 8)
Also, are you sure the .ibd files are OK?


> is there anyway that I can do it without crashing
> the whole server?

It looks like you have to rebuild the server from scratch. Thus, downtime is inevitable.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB corrupted by ransomware attack
121
July 04, 2018 11:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.