MySQL Forums
Forum List  »  Data Recovery

Recover InnoDB table
Posted by: Eldon Down
Date: April 19, 2021 09:21AM

Windows Server 2016
MySQL 8.0.23
Recent server crash. I have a complete backup of the server from shortly before the crash. There is one specific table I wish to restore, and so far, have tried the following without success:
1) Copy entire database folder containing the table, as well as files from root of Data folder, and the 'sys' db folder, and the my.ini file. Attempting to start the server with this results in service crash with "Multiple files found for the same tablespace ID"
2) with running service, create new schema, and run create statement for the table. Then discard tablespace, copy idb file, and import tablespace. The last command fails with "Error Code: 1034. Incorrect key file for table 'filedata'; try to repair it"
Any other possible fixes I've found seem to revolve around utilities that require compiling, which I do not know how to do. Option 1) would be the preferred route to get working, as there is other less critical data I would like to recover.
Thanks in advance

Options: ReplyQuote

Written By
Recover InnoDB table
April 19, 2021 09:21AM
April 19, 2021 09:38AM
April 19, 2021 10:05AM
April 19, 2021 12:16PM
April 19, 2021 12:42PM
April 19, 2021 11:21AM
April 19, 2021 05:01PM
April 20, 2021 07:12AM
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.