MySQL 8.0 Database Administrator — Question 128

A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

Answer options

• A. ibtmp1
• B. undo_001
• C. ib_buffer_pool
• D. ibdata1
• E. mysql.ibd
• F. ib_logfile0

Correct answer: C, E

Explanation

The correct answers are C and E because the ib_buffer_pool file is essential for storing data in memory, and mysql.ibd contains the actual data for the MySQL tables. The other files are either temporary, related to undo logs, or log files that are not required for a clean restart after a full shutdown.