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 questionsWhen 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.
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.
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.
Keep practicing
Take the free 1Z0-908 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-908 practice questions
- Question 2You must run multiple instances of MySQL Server on a single host. Which three methods are…
- Question 3Which two tools are available to monitor the global status of InnoDB locking? (Choose two…
- Question 4Which two MySQL Server accounts are locked by default? (Choose two.)
- Question 5All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Y…
- Question 6t is a non-empty InnoDB table. Examine these statements, which are executed in one sessio…
- Question 8Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostnam…
