MySQL Forums
Forum List  »  Data Recovery

Re: Restore overwritten tables from ibdata1 and logfiles
Posted by: Aleksandr Kuzminsky
Date: July 03, 2020 11:17AM

> What information I can restore from these files? Tables structure at least?

depends on innodb_file_per_table setting. If OFF - the recovery may be possible - google undrop-for-innodb.
If ON - the data were in *.ibd files, they're gone after a DROP. The recovery is very tedious with not many chances and a lot of factors that can push it over fence in either direction.

Partially, the table structure may be recoverable from InnoDB dictionary that is stored in ibdata1. Check out sys_parser from undrop-for-innodb.

Good luck!

P.S. and yes, backup the database if it is of any value.

Options: ReplyQuote

Written By
Re: Restore overwritten tables from ibdata1 and logfiles
July 03, 2020 11:17AM

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.