MySQL5.7 OCP每日一题--Day18

Question: 26

What two statements are true regarding FLUSH TABLES FOR EXPORT? 
A. It can be used to export TEMPORARY tables. 
B. Table only exports when the table has its own tablespace. 
C. The InnoDB Storage engine must be used for the table being exported. 
D. It is the safest way to extract tables from the shared tablespace. 
E. Partitioned tables are not supported. 

复制

答案： BC
解析： flush tables for export，常用于表空间传输、备份等。要求必须时innodb表且打开innodb_file_per_table。