MySQL Forums
Forum List  »  Data Recovery

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"

Options: ReplyQuote


Subject
Views
Written By
Posted
514
April 19, 2021 09:21AM
239
April 19, 2021 09:38AM
Re: Recover InnoDB table
443
April 19, 2021 10:05AM
257
April 19, 2021 12:16PM
266
April 19, 2021 12:42PM
230
April 19, 2021 11:21AM
215
April 19, 2021 05:01PM
226
April 20, 2021 07:12AM
194
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.