Which of the following is/are properties of the mysqldump client program?

The correct answer is A. It dumps table contents to a file. B. It can put complete dump files on both the client and server host. The mysqldump client program dumps table contents to files. It is useful for making database backups or for transferring database contents to another server. mysqldump can export tables as tab-delimited data files or produce SQL-format dump files that contain CREATE TABLE and…

Using MySQL Client Programs

Question

Options

AIt dumps table contents to a file.
BIt can put complete dump files on both the client and server host.
CIt can only dump files to the server host.
DIt bypasses the server and reads the corresponding data files directly.

How the community answered

(30 responses)

A
83% (25)
C
7% (2)
D
10% (3)

Explanation

The mysqldump client program dumps table contents to files. It is useful for making database backups or for transferring database contents to another server. mysqldump can export tables as tab-delimited data files or produce SQL-format dump files that contain CREATE TABLE and INSERT statements for re-creating the dumped files.

Topics

#mysqldump#backup#data export#dump file location

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice