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

You are backing up raw InnoDB files by using mysqlbackup.

Which two groups of files will be backed up during a full backup? (Choose two.)

    Correct Answer: D, E

    When performing a full backup of raw InnoDB files using mysqlbackup, both the individual tablespace data files (*.ibd files) and the InnoDB redo log files (ib_logfile* files) are included. The *.ibd files contain the actual data for the InnoDB tables, and the ib_logfile* files contain the redo logs that are used for recovery purposes in case of a crash. These two types of files are essential for a complete backup of an InnoDB database.

Discussion
FelipeKOptions: DE

InnoDB data files (ibdata files and .ibd files) InnoDB redo log files (#ib_redo N files in MySQL 8.0.30 and higher or ib_logfile files in earlier releases)

marklvOptions: AD

AB. CSV tables create CSM files, innodb stores data in idb files

marklv

Sorry its says its only backing up innodb. https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/meb-files-backed-up-innodb.html D and E. ibd and ib_logfile