MySQL Options- mysqldump and mysqlpump

Question 1

–bind-address

Answer 1

For mysqldump and mysqlpump commands

Use specified network interface to connect to MySQL Server

Question 2

–character-sets-dir

Answer 2

For mysqldump and mysqlpump commands

Directory where character sets are installed

Question 3

–column-statistics

Answer 3

For mysqldump and mysqlpump commands

Write ANALYZE TABLE statements to generate statistics histograms

Question 4

–complete-insert

Answer 4

For mysqldump and mysqlpump commands

Use complete INSERT statements that include column names

Question 5

–compress

Answer 5

For mysqldump and mysqlpump commands

Compress all information sent between client and server

Question 6

–compression-algorithms

Answer 6

For mysqldump and mysqlpump commands

Permitted compression algorithms for connections to server

Question 7

–debug

Answer 7

For mysqldump and mysqlpump commands

Write debugging log

Question 8

–debug-check

Answer 8

For mysqldump and mysqlpump commands

Print debugging information when program exits

Question 9

–debug-info

Answer 9

For mysqldump and mysqlpump commands

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

Question 10

–default-auth

Answer 10

For mysqldump and mysqlpump commands

Authentication plugin to use

Question 11

–defaults-extra-file

Answer 11

For mysqldump and mysqlpump commands

Read named option file in addition to usual option files

Question 12

–hex-blob

Answer 12

For mysqldump and mysqlpump commands

Dump binary columns using hexadecimal notation

Question 13

–login-path

Answer 13

For mysqldump and mysqlpump commands

Read login path options from .mylogin.cnf

Question 14

–net-buffer-length

Answer 14

For mysqldump and mysqlpump commands

Buffer size for TCP/IP and socket communication

Question 15

–no-create-info

Answer 15

For mysqldump and mysqlpump commands

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

Question 16

–port

Answer 16

For mysqldump and mysqlpump commands

TCP/IP port number for connection

Question 17

–replace

Answer 17

For mysqldump and mysqlpump commands

Write REPLACE statements rather than INSERT statements

Question 18

–result-file

Answer 18

For mysqldump and mysqlpump commands

Direct output to a given file

Question 19

–set-gtid-purged

Answer 19

For mysqldump and mysqlpump commands

Whether to add SET @@GLOBAL.GTID_PURGED to output

Question 20

–single-transaction

Answer 20

For mysqldump and mysqlpump commands

Issue a BEGIN SQL statement before dumping data from server

Question 21

–ssl-ca

Answer 21

For mysqldump and mysqlpump commands

File that contains list of trusted SSL Certificate Authorities

Question 22

–ssl-cert

Answer 22

For mysqldump and mysqlpump commands

File that contains X.509 certificate

Question 23

–ssl-cipher

Answer 23

For mysqldump and mysqlpump commands

Permissible ciphers for connection encryption

Question 24

–ssl-cripath

Answer 24

For mysqldump and mysqlpump commands

Directory that contains certificate revocation-list files

Question 25

--ssl-mode

Answer 25

For mysqldump and mysqlpump commands Desired security state of connection to server

Question 26

--tls-version

Answer 26

For mysqldump and mysqlpump commands Permissible TLS protocols for encrypted connections

Question 27

--tz-utc

Answer 27

For mysqldump and mysqlpump commands Add SET TIME_ZONE='+00:00' to dump file

Question 28

--apply-replica-statements

Answer 28

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

Question 29

--apply-slave-statements

Answer 29

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

Question 30

--compact

Answer 30

For mysqldump Produce more compact output

Question 31

--delete-master-logs

Answer 31

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

Question 32

--delete-source-logs

Answer 32

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

Question 33

--disable-keys

Answer 33

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

Question 34

--dump-replica

Answer 34

For mysqldump Include CHANGE REPLICATION SOURCE TO statement that lists binary log coordinates of replica's source

Question 35

--dump-slave

Answer 35

For mysqldump Include CHANGE MASTER statement that lists binary log coordinates of replica's source

Question 36

--flush-logs

Answer 36

For mysqldump Flush MySQL server log files before starting dump

Question 37

--flush-privileges

Answer 37

For mysqldump Emit a FLUSH PRIVILEGES statement after dumping mysql database

Question 38

--force

Answer 38

For mysqldump Continue even if an SQL error occurs during a table dump

Question 39

--master-data

Answer 39

For mysqldump Write the binary log file name and position to the output

Question 40

--no-autocommit

Answer 40

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

Question 41

--no-defaults

Answer 41

For mysqldump Read no option files

Question 42

--no-data

Answer 42

For mysqldump Do not dump table contents

Question 43

--opt

Answer 43

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

Question 44

--quick

Answer 44

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

Question 45

--source-data

Answer 45

For mysqldump Write the binary log file name and position to the output

Question 46

--default-parallelism

Answer 46

For mysqlpump Default number of threads for parallel processing

Question 47

--defer-table-indexes

Answer 47

For mysqlpump For reloading, defer index creation until after loading table rows

Question 48

--parallel-schemas

Answer 48

For mysqlpump Specify schema-processing parallelism

Question 49

--users

Answer 49

For mysqlpump Dump user accounts

Question 50

--insert-ignore

Answer 50

For mysqldump and mysqlpump commands Write INSERT IGNORE rather than INSERT statements

Question 51

--lock-all-tables

Answer 51

For mysqldump Lock all tables across all databases

Question 52

--lock-tables

Answer 52

For mysqldump Lock all tables before dumping them