Aikesheng Open Source Community
Jul 14, 2021 · Databases
Recovering a Deleted InnoDB .ibd File and Detecting Missing Tablespace in MySQL
This article demonstrates how to simulate accidental deletion of a MySQL InnoDB .ibd file, observe the impact on queries, recover the file using the file descriptor in /proc, restart MySQL, and verify that various DDL operations can detect the missing tablespace.
Database TroubleshootingInnoDBMySQL
0 likes · 12 min read