问题描述：
[单选]
You have been notified that the ‘apps’ ． ‘reports’ table has been accidentally truncated．You have single file mysqldump backup available taken prior to the truncate． The backup contains all the tables from the instance， and the ‘apps’ ． ‘reports’ table must be restored without affecting the other remaining databases and tables．已通知您“应用程序”。“reports”表被意外截断。在截断之前，您有一个可用的mysqldump备份文件。备份包含实例中的所有表和“apps”。“reports”表必须在不影响其他剩余数据库和表的情况下还原。Which restore option is suitable in this scenario？ 在这种情况下，哪个恢复选项是合适的？
A．Restore the backup to another databases instance and obtain a copy of the reports table individually. 将备份还原到另一个数据库实例，并分别获取报表表的副本。
B．Extract the ‘apps’ . ‘reports’ table from the backup using the SOURCE command.
C．Execute LOAD DATA INFILE ‘backup.sql’ SCHEMA=’apps’ TABLE= ‘reports’
D．Execute mysqldump on the backup,sql file and apply – filter arguments to obtain only the ‘apps’.‘reportys’ table.
参考答案：查看无
答案解析：无
☆收藏
答案解析：无
☆收藏
上一篇：Which two requirements would lead towards a high availability solution？ 哪两个需求将导致高可用性解决方案？（）
下一篇：A user has deleted the wrong row in a table and you are preparing a point-in-time recovery skipping the DELETE event．用户删除了表中的错误行，而您正在准备时间点恢复，跳过删除事件。The server is configured with( )You have identified that the DELETE statement to skip has the Global Transaction Identifier （GTID） ‘dbbe7da-fe25-11e2-b6c7-0800274aa49e( )5 and you replay the binary log with( )mysqlbinlog –exclude-gtids=’dbbe07da-fe25-11e2-b6c7-0800274aa49e( )5’ binlog．000002 | mysqlHowever all events were skipped instead of just the one deleting the wrong row．但是，所有事件都被跳过，而不仅仅是删除错误行的事件。What is the reason for this？这是什么原因？
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.对因为标准化物资不合格导致不 2.在具体工程的招标环节中，如分 3.5G套餐（融合版）169元中