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
421
April 19, 2021 09:21AM
198
April 19, 2021 09:38AM
Re: Recover InnoDB table
268
April 19, 2021 10:05AM
197
April 19, 2021 12:16PM
185
April 19, 2021 12:42PM
173
April 19, 2021 11:21AM
162
April 19, 2021 05:01PM
179
April 20, 2021 07:12AM
153
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.