search

toxyl / mysql-innodb-recovery

A shell script that helps to recover corrupted MySQL databases (InnoDb engine).
2 stars 1 forks source link

Recover *ibd #1

Open leandrocombr opened 2 years ago

leandrocombr commented 2 years ago

Hi!

I had 3 databases accidentally deleted on my server. And the Backup is corrupted!

Faced with the fact, I managed to recover the *.ibd files from the server

However, when importing, the following message appears:

ALTER TABLE table IMPORT TABLESPACE;

$ tail -f mysql.log 2022-10-23T17:56:27.745864Z 561230 [Note] [MY-012164] [InnoDB] Sync to disk 2022-10-23T17:56:27.891192Z 561230 [Note] [MY-012166] [InnoDB] Sync to disk - done! 2022-10-23T17:56:27.891365Z 561230 [Note] [MY-012774] [InnoDB] Phase I - Update all pages 2022-10-23T17:56:28.193391Z 561230 [Warning] [MY-012769] [InnoDB] Page 24064 at offset 394264576 looks corrupted in file ./database/table.ibd 2022-10-23T17:56:28.193497Z 561230 [Note] [MY-012770] [InnoDB] Failed to import tablespace of table 'database/table': Data structure corruption

How do I recover accidentally deleted database/tables?

toxyl commented 2 years ago

I have no idea what this error means, but maybe this has something to do with your case: https://dba.stackexchange.com/a/187723

Maybe this option is also useful: https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html