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.
–bind-address
For mysqldump and mysqlpump commands
Use specified network interface to connect to MySQL Server
–character-sets-dir
For mysqldump and mysqlpump commands
Directory where character sets are installed
–column-statistics
For mysqldump and mysqlpump commands
Write ANALYZE TABLE statements to generate statistics histograms
–complete-insert
For mysqldump and mysqlpump commands
Use complete INSERT statements that include column names
–compress
For mysqldump and mysqlpump commands
Compress all information sent between client and server
–compression-algorithms
For mysqldump and mysqlpump commands
Permitted compression algorithms for connections to server
–debug
For mysqldump and mysqlpump commands
Write debugging log
–debug-check
For mysqldump and mysqlpump commands
Print debugging information when program exits
–debug-info
For mysqldump and mysqlpump commands
Print debugging information, memory, and CPU statistics when program exits
–default-auth
For mysqldump and mysqlpump commands
Authentication plugin to use
–defaults-extra-file
For mysqldump and mysqlpump commands
Read named option file in addition to usual option files
–hex-blob
For mysqldump and mysqlpump commands
Dump binary columns using hexadecimal notation
–login-path
For mysqldump and mysqlpump commands
Read login path options from .mylogin.cnf
–net-buffer-length
For mysqldump and mysqlpump commands
Buffer size for TCP/IP and socket communication
–no-create-info
For mysqldump and mysqlpump commands
Do not write CREATE TABLE statements that re-create each dumped table
–port
For mysqldump and mysqlpump commands
TCP/IP port number for connection
–replace
For mysqldump and mysqlpump commands
Write REPLACE statements rather than INSERT statements
–result-file
For mysqldump and mysqlpump commands
Direct output to a given file
–set-gtid-purged
For mysqldump and mysqlpump commands
Whether to add SET @@GLOBAL.GTID_PURGED to output
–single-transaction
For mysqldump and mysqlpump commands
Issue a BEGIN SQL statement before dumping data from server