What are three facts about backups with mysqldump?
A.
Can back up a remote database server
B.
Allow a consistent backup to be taken
C.
Are always faster to restore than binary backups
D.
Are able to back up specific items within a database
E.
Create automatically compressed backups
F.
Will lock all storage engines for duration of backup
Explanation:
I think A,B and D
A, B, F (for not “–lock-tables=0”)
A,B, and D…. to me F is more n option than a fact
I think A,B and D too
A, B, D
F is out because of the ‘Will’ language.
E and F are definitely wrong.
A, B, D
A- true
B- true with flush tables with read lock
C- false, requires sql processing
D- true, see mysqldump options
E- false, you need to `|gzip -c`. The -C compresses transmission, not storage.
F- false, you can’t lock storage engines.