MySQL Forums
Forum List  »  Data Recovery

Rebuild a broken mysql database using .frm or .ibd data. SQL files are 0byte. Resynchronize mysql Software for Windows to restore .ibd data.
Posted by: Sero Hazr
Date: August 23, 2023 04:14AM

MySQL files (after MySQL crashed) have reduced to 0 bytes.

However, all databases in the form of .ibd and .frm are still present in the /var/lib/mysql folder.

Is there any software available for recovery?

Free of charge? Open source?

I tried to restore / overwrite these .frm and .ibd into a new database (using a guide). Unfortunately this does not work. MySQL makes errors and can't read the columns anymore.

After trying to recover the corrupted MySQL database or IBD DATA with a new MySQL.For this I created and overwrote the .ibd file and ran the commands:(ALTER TABLE tablename DISCARD TABLESPACE;)(ALTER TABLE tablename IMPORT TABLESPACE;)did not work! :(

Can someone please help me?The platform does not matter, no matter if it is Linux, Mac or Windows. The program should be free of charge.

Thanks a lot!

Options: ReplyQuote


Subject
Views
Written By
Posted
Rebuild a broken mysql database using .frm or .ibd data. SQL files are 0byte. Resynchronize mysql Software for Windows to restore .ibd data.
383
August 23, 2023 04:14AM


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.