Which restore option is suitable in this scenario?

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?

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:



Leave a Reply 4

Your email address will not be published. Required fields are marked *


wolfsrudel

wolfsrudel

I would consider A.

Thomas

Thomas

Consider D but should be –table option