What are three facts about backups with mysqldump?

What are three facts about backups with mysqldump?

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:



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Ispanico

Ispanico

I think A,B and D

wolfsrudel

wolfsrudel

A, B, F (for not “–lock-tables=0”)

nitro

nitro

A,B, and D…. to me F is more n option than a fact

vasben

vasben

I think A,B and D too

Steve

Steve

A, B, D

F is out because of the ‘Will’ language.

Tim Little

Tim Little

E and F are definitely wrong.

mutex

mutex

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.