Re: Recover InnoDB table
Posted by:
Eldon Down
Date: April 19, 2021 10:05AM
I have a dump from about 12 hours prior to the server backup, but it does not include the table in question due to it being about 100GB. Can you know what *should* be copied in addition to the db folder and ibdata1 file? I've tried quite a few combinations of files. I just tried copying the files from the backup, and putting only the one ibd file into the db folder, and now I'm getting the following errors: "Space ID in fsp header is 258, but in the page header it is 16384" and "Tablespace flags are invalid in datafile: .\ibdata1, Space ID:4294967295, Flags: 261" and "Corrupted page [page id: space=4294967295, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer"
Subject
Views
Written By
Posted
1511
April 19, 2021 09:21AM
567
April 19, 2021 09:38AM
Re: Recover InnoDB table
1318
April 19, 2021 10:05AM
683
April 19, 2021 12:16PM
697
April 19, 2021 12:42PM
566
April 19, 2021 11:21AM
530
April 19, 2021 05:01PM
567
April 20, 2021 07:12AM
517
September 08, 2021 07:29AM
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.