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.
Explanation:
I would consider A.
A
A
Consider D but should be –table option