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.