Mysql OCP第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.

Answer: A,B

使用mysqldump创建的备份--所有数据库

使用刷新表创建的备份…用于导出