mysqlpump — A Database Backup Program 516 Option Name Description Introduced Deprecated --no-create-db Do not write CREATE DATABASE statements --no-create-info Do not write CREATE TABLE statements that re-create each dumped table --no-defaults Read no option files --parallel-schemas Specify schema- processing parallelism --password Password to use when connecting to server --plugin-dir Directory where plugins are installed --port TCP/IP port number for connection --print-defaults Print default options --protocol Transport protocol to use --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 --single-transaction Dump tables within single transaction --skip-definer Omit DEFINER and SQL SECURITY clauses from view and stored program CREATE statements --skip-dump-rows Do not dump table rows --socket Unix socket file or Windows named pipe to use