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?
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?