Re: Restore overwritten tables from ibdata1 and logfiles
> 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.
Subject
Views
Written By
Posted
843
July 03, 2020 06:25AM
424
July 03, 2020 07:11AM
409
July 03, 2020 07:24AM
Re: Restore overwritten tables from ibdata1 and logfiles
630
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.