# MySQL误DROP表恢复,innodb_file_per_table=ON

## 删除Country表并恢复

innodb每个表包含两个文件.frm文件包含建表语句.ibd文件包含数据

drop table后,.frm和.ibd文件也被删除了

## 恢复表

### 使用stream_parser解析数据文件

Since there is no file with data available, we will scan through all the storage device as raw device and look for data that fit in expected structure of the database pages. By the way, this approach can be taken in case we have corrupted data files. If some data is corrupted, recovery tool can perform partial data recovery. In the options of the tool we specify name of the device and device size (can be approximate).

0000000000000729.page使我们需要的.这里需要country的建表语句country.sql,所以说请备份好元数据.这里undrop-for-innodb自带了sakila的建表语句以供实验使用