Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 69

A valid raw backup of the shop.customers MyISAM table was taken.

You must restore the table.

You begin with these steps:

1. Confirm that secure_file_priv=’/var/tmp’

2. mysql> DROP TABLE shop.customers;

3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/

Which two actions are required to complete the restore? (Choose two.)

    Correct Answer: B, G

    To restore a MyISAM table, you need to ensure all the relevant table files are in the correct directory. After copying the data files (customers.MYD and customers.MYI) to /var/lib/mysql/shop/, you also need to copy the table definition file (customers.frm) to the same location as it defines the structure of the table. Therefore, copying the .sdi file is not necessary here. Afterward, running `ALTER TABLE shop.customers IMPORT TABLESPACE` integrates these files back into MySQL, completing the restore process.

Discussion
LrnsTghOptions: BF

location sdi file match

FelipeKOptions: AF

The correct answer are A and F. I tested it.

marklvOptions: AF

A and F, tested, import table works for myisam in 8

marklv

But the commands forgot the quotes, so technically it won't work, but its what it meant

marklv

Correction, B and F, A file location doesn't match f

DhanushkaOptions: AD

Import tablespace only for Innodb