mysqldump — A Database Backup Program Option Name Description Introduced Deprecated --pipe Connect to server using named pipe (Windows only) --plugin-dir Directory where plugins are installed --port TCP/IP port number for connection --print-defaults Print default options --protocol Transport protocol to use --quick Retrieve rows for a table from the server a row at a time --quote-names Quote identifiers within backtick characters --replace Write REPLACE statements rather than INSERT statements --result-file Direct output to a given file --routines Dump stored routines (procedures and functions) from dumped databases --server-public-key-path Path name to file containing RSA public key --set-charset Add SET NAMES default_character_set to output --set-gtid-purged Whether to add SET @@GLOBAL.GTID_PURGED to output --shared-memory-base- name Shared-memory name for shared-memory connections (Windows only) --show-create-skip- secondary-engine Exclude SECONDARY ENGINE clause from CREATE TABLE statements 8.0.18 --single-transaction Issue a BEGIN SQL statement before dumping data from server --skip-add-drop-table Do not add a DROP TABLE statement before 479