MySQL5.7 OCP每日一题--Question: 13

A single InnoDB table has been dropped by accident. You are unable to use an additional 
intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? 
A. a backup created with mysqldump --all-databases 
B. a backup created using FLUSH TABLES … FOR EXPORT 
C. an up-to-date replication slave 
D. a file system-level snapshot 
E. a file system copy created while MySQL was shut down. 
复制

答案：AB
解析：误删innodb单表如何恢复，不能使用额外的中间实例并且不停止原实例。A备份了所有库，包含需要的表，可以通过脚本处理后导入，B可以使用表空间导入技术恢复单表，C如果误删除是通过sql操作，binlog传递给slave，导致slave也删除，因此无法通过slave恢复，如果误删除是系统命令，则可以通过slave恢复。D文件系统快照恢复需要重启实例，E需要启动一个额外的实例