Question

Which two are true regarding MySQL binary and text backups?

a) Binary backups are usually faster than text backups.
b) Binary backups are usually slower than text backups.
c) Text backups are human-readable while binary backups are not.
d) Binary backups are not portable across different operating systems.

Answer 1

Binary backups tend to be faster than text backups and text backups are human-readable, unlike binary backups.

Step-by-step explanation:

Regarding MySQL binary and text backups, two statements are true:

• Binary backups are usually faster than text backups. This is because binary backups involve copying the binary data files directly, which is a more efficient process than converting the data to text format.
• Text backups are human-readable while binary backups are not. Text backups, often in the form of SQL statements, are easier to understand and manipulate for humans, but they tend to be larger in size and slower to create and restore.

It is important to note that binary backups are generally portable across different operating systems, which contradicts one of the options provided. While some variables, such as file paths or system-specific configurations, might need to be adjusted when moving between systems, the binary data itself can typically be transferred.