MySQL Options- mysqldump and mysqlpump Flashcards

Does not cover all options for mysqldump and mysqlpump, just ones that might be harder to remember their functionality.

1
Q

–bind-address

A

For mysqldump and mysqlpump commands

Use specified network interface to connect to MySQL Server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

–character-sets-dir

A

For mysqldump and mysqlpump commands

Directory where character sets are installed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

–column-statistics

A

For mysqldump and mysqlpump commands

Write ANALYZE TABLE statements to generate statistics histograms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

–complete-insert

A

For mysqldump and mysqlpump commands

Use complete INSERT statements that include column names

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

–compress

A

For mysqldump and mysqlpump commands

Compress all information sent between client and server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

–compression-algorithms

A

For mysqldump and mysqlpump commands

Permitted compression algorithms for connections to server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

–debug

A

For mysqldump and mysqlpump commands

Write debugging log

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

–debug-check

A

For mysqldump and mysqlpump commands

Print debugging information when program exits

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

–debug-info

A

For mysqldump and mysqlpump commands

Print debugging information, memory, and CPU statistics when program exits

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

–default-auth

A

For mysqldump and mysqlpump commands

Authentication plugin to use

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

–defaults-extra-file

A

For mysqldump and mysqlpump commands

Read named option file in addition to usual option files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

–hex-blob

A

For mysqldump and mysqlpump commands

Dump binary columns using hexadecimal notation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

–login-path

A

For mysqldump and mysqlpump commands

Read login path options from .mylogin.cnf

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

–net-buffer-length

A

For mysqldump and mysqlpump commands

Buffer size for TCP/IP and socket communication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

–no-create-info

A

For mysqldump and mysqlpump commands

Do not write CREATE TABLE statements that re-create each dumped table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

–port

A

For mysqldump and mysqlpump commands

TCP/IP port number for connection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

–replace

A

For mysqldump and mysqlpump commands

Write REPLACE statements rather than INSERT statements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

–result-file

A

For mysqldump and mysqlpump commands

Direct output to a given file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

–set-gtid-purged

A

For mysqldump and mysqlpump commands

Whether to add SET @@GLOBAL.GTID_PURGED to output

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

–single-transaction

A

For mysqldump and mysqlpump commands

Issue a BEGIN SQL statement before dumping data from server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

–ssl-ca

A

For mysqldump and mysqlpump commands

File that contains list of trusted SSL Certificate Authorities

22
Q

–ssl-cert

A

For mysqldump and mysqlpump commands

File that contains X.509 certificate

23
Q

–ssl-cipher

A

For mysqldump and mysqlpump commands

Permissible ciphers for connection encryption

24
Q

–ssl-cripath

A

For mysqldump and mysqlpump commands

Directory that contains certificate revocation-list files

25
Q

–ssl-mode

A

For mysqldump and mysqlpump commands

Desired security state of connection to server

26
Q

–tls-version

A

For mysqldump and mysqlpump commands

Permissible TLS protocols for encrypted connections

27
Q

–tz-utc

A

For mysqldump and mysqlpump commands

Add SET TIME_ZONE=’+00:00’ to dump file

28
Q

–apply-replica-statements

A

For mysqldump

Include STOP REPLICA prior to CHANGE REPLICATION SOURCE TO statement and START REPLICA at end of output

29
Q

–apply-slave-statements

A

For mysqldump

Include STOP SLAVE prior to CHANGE MASTER statement and START SLAVE at end of output

30
Q

–compact

A

For mysqldump

Produce more compact output

31
Q

–delete-master-logs

A

For mysqldump

On a replication source server, delete the binary logs after performing the dump operation

32
Q

–delete-source-logs

A

For mysqldump

On a replication source server, delete the binary logs after performing the dump operation

33
Q

–disable-keys

A

For mysqldump

For each table, surround INSERT statements with statements to disable and enable keys

34
Q

–dump-replica

A

For mysqldump

Include CHANGE REPLICATION SOURCE TO statement that lists binary log coordinates of replica’s source

35
Q

–dump-slave

A

For mysqldump

Include CHANGE MASTER statement that lists binary log coordinates of replica’s source

36
Q

–flush-logs

A

For mysqldump

Flush MySQL server log files before starting dump

37
Q

–flush-privileges

A

For mysqldump

Emit a FLUSH PRIVILEGES statement after dumping mysql database

38
Q

–force

A

For mysqldump

Continue even if an SQL error occurs during a table dump

39
Q

–master-data

A

For mysqldump

Write the binary log file name and position to the output

40
Q

–no-autocommit

A

For mysqldump

Enclose the INSERT statements for each dumped table within SET autocommit = 0 and COMMIT statements

41
Q

–no-defaults

A

For mysqldump

Read no option files

42
Q

–no-data

A

For mysqldump

Do not dump table contents

43
Q

–opt

A

For mysqldump

Shorthand for –add-drop-table –add-locks –create-options –disable-keys –extended-insert –lock-tables –quick –set-charset

44
Q

–quick

A

For mysqldump

Retrieve rows for a table from the server a row at a time

45
Q

–source-data

A

For mysqldump

Write the binary log file name and position to the output

46
Q

–default-parallelism

A

For mysqlpump

Default number of threads for parallel processing

47
Q

–defer-table-indexes

A

For mysqlpump

For reloading, defer index creation until after loading table rows

48
Q

–parallel-schemas

A

For mysqlpump

Specify schema-processing parallelism

49
Q

–users

A

For mysqlpump

Dump user accounts

50
Q

–insert-ignore

A

For mysqldump and mysqlpump commands

Write INSERT IGNORE rather than INSERT statements

51
Q

–lock-all-tables

A

For mysqldump

Lock all tables across all databases

52
Q

–lock-tables

A

For mysqldump

Lock all tables before dumping them