MySQL Forums
Forum List  »  InnoDB

Fix .ibd file problem or restore database before wrong query
Posted by: Mohammed Qader
Date: April 04, 2022 07:24PM

I executed a wrong query and then sent another query to fix my error but it didn't work but I found the .ibd file and when I opened it I found my data but in encrypted form. Can I decrypt it and get my data back?? Or cancel the wrong queries

When I try to recover data by command

ALTER TABLE (Table name) IMPORT TABLESPACE
Executes the update query, which is the query you erred It shows me the modified data and not the data before the update

Options: ReplyQuote


Subject
Views
Written By
Posted
Fix .ibd file problem or restore database before wrong query
226
April 04, 2022 07:24PM


Sorry, only registered users may post in this forum.

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.