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
Subject
Views
Written By
Posted
Recover InnoDB table
1380
April 19, 2021 09:21AM
523
April 19, 2021 09:38AM
1213
April 19, 2021 10:05AM
610
April 19, 2021 12:16PM
638
April 19, 2021 12:42PM
512
April 19, 2021 11:21AM
481
April 19, 2021 05:01PM
510
April 20, 2021 07:12AM
473
September 08, 2021 07:29AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.