1Z0-908 practice question 16 of 25

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.)

Full set: 140 questions
Answer options
A: ibbackup files
B: *.CSM files
C: *.sdi files
D: *.ibd files Correct answer
E: ib_logfile* files Correct answer
Correct Answer:
D. *.ibd files; E. ib_logfile* files
Explanation

When mysqlbackup performs a full backup of a MySQL instance using InnoDB, it conducts a "hot" backup by copying the essential raw files. The process involves copying the InnoDB data files, which include the system tablespace (ibdata1) and, if innodbfilepertable is enabled (the default), the individual tablespace files (.ibd). To ensure transactional consistency, mysqlbackup also copies the InnoDB redo log files (iblogfile). These log files record all modifications made during the backup process, allowing the database to be restored to a perfectly consistent state.

Why Incorrect

A. ibbackup files are temporary files created by the mysqlbackup utility during its operation; they are not the original source database files being backed up.
B. .CSM files are checksum files associated with the MyISAM storage engine. The question specifically asks about backing up raw InnoDB files.
C. In modern MySQL versions (8.0+), Serialized Dictionary Information (.sdi) for InnoDB tables is embedded within the .ibd tablespace files, not stored separately.

References

1. Official MySQL 8.0 Documentation, "3.1 How MySQL Enterprise Backup Works": "For InnoDB tables, mysqlbackup copies the tablespace files (.ibd files and the system tablespace files) to the backup directory... While the data files are being copied, mysqlbackup continuously monitors the InnoDB log files (iblogfile) and copies the changes to a temporary file inside the backup directory." This confirms that both .ibd and iblogfile are copied from the source.

2. Official MySQL 8.0 Documentation, "4.1 Performing a Full Backup": "A full backup backs up the entire set of data in a MySQL instance. It includes all databases and all tables, including the InnoDB system tablespace, data files, and log files..." This explicitly lists the InnoDB data files and log files as components of a full backup.

Scroll to Top