IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL 5.6 Database Administrator-053-Which restore option is suitable in this scenario?

    royalwzy发表于 2015-09-03 02:59:46
    love 0
    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. 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. 答案:A


沪ICP备19023445号-2号
友情链接