• --exclude-routines= routine_list 

Do not dump the events in routine_list , which is a list of one or more comma-separated routine (stored procedure or function) names. Multiple instances of this option are additive. For more information, see mysqlpump Object Selection. 

• --exclude-tables= table_list 

Do not dump the tables in table_list , which is a list of one or more comma-separated table names. Multiple instances of this option are additive. For more information, see mysqlpump Object Selection. 

• --exclude-triggers= trigger_list 

Do not dump the triggers in trigger_list , which is a list of one or more comma-separated trigger names. Multiple instances of this option are additive. For more information, see mysqlpump Object Selection. 

• --exclude-users= user_list 

Do not dump the user accounts in user_list , which is a list of one or more comma-separated account names. Multiple instances of this option are additive. For more information, see mysqlpump Object Selection. 

• --extended-insert= N 

Write INSERT  statements using multiple-row syntax that includes several VALUES  lists. This results in a smaller dump file and speeds up inserts when the file is reloaded. 

The option value indicates the number of rows to include in each INSERT  statement. The default is 250. A value of 1 produces one INSERT  statement per table row. 

• --get-server-public-key 

Request from the server the public key required for RSA key pair-based password exchange. This option applies to clients that authenticate with the caching_sha2_password  authentication plugin. For that plugin, the server does not send the public key unless requested. This option is ignored for accounts that do not authenticate with that plugin. It is also ignored if RSA-based password exchange is not used, as is the case when the client connects to the server using a secure connection. 

If --server-public-key-path= file_name  is given and specifies a valid public key file, it takes precedence over --get-server-public-key . 

For information about the caching_sha2_password  plugin, see Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . 

• --hex-blob 

Dump binary columns using hexadecimal notation (for example, ’abc’  becomes 0x616263 ). The affected data types are BINARY , VARBINARY , BLOB  types, BIT , all spatial data types, and other non- binary data types when used with the binary  character set. 

• --host= host_name , -h host_name 

Dump data from the MySQL server on the given host. 

