Which of the following steps describe how to do a proper binary backup of InnoDB data?

Question

Options

• AStop the server prior to the backup
• BStop the server or lock the tables prior to the backup
• CMake a copy of the .frm files.
• DMake a copy of the .MYD and .MYI files.
• EMake a copy of the InnoDB log and tablespace files.
• FMake a copy of any InnoDB configuration options.

• A
  76% (44)
• B
  10% (6)
• D
  14% (8)

Explanation

To make an InnoDB binary backup, use the following procedure: 1. Stop the server for the duration of the copy operation. 2. The tablespace must not be in use when copying the tablespace files. 2. Make sure that the server shut down without error. Binary InnoDB backups require a clean shutdown to be certain that the server has completed any pending transactions. 3. Make a copy of each of the following components: The .frm file for each InnoDB table. The tablespace files. This includes the files for the shared tablespace. It also includes the .ibd files if you have configured InnoDB to use per-table tablespaces. The InnoDB log files. Any InnoDB configuration options, such as those stored in option files. The configuration options are required in case you need to restore the backup from scratch. In that case, you'll need to know how the tablespace and log files were created originally. 4. Restart the server.

No community discussion yet for this question.