For TCP/IP connections, the port number to use. 

• --print-defaults 

Print the program name and all options that it gets from option files. 

For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . 

• --protocol={TCP|SOCKET|PIPE|MEMORY} 

The transport protocol to use for connecting to the server. It is useful when the other connection parameters normally result in use of a protocol other than the one you want. For details on the permissible values, see Section 4.2.7, “Connection Transport Protocols” . 

• --replace 

Write REPLACE  statements rather than INSERT  statements. 

• --result-file= file_name 

Direct output to the named file. The result file is created and its previous contents overwritten, even if an error occurs while generating the dump. 

This option should be used on Windows to prevent newline 
  characters from being converted to \r
 carriage return/newline sequences. 

• --routines 

Include stored routines (procedures and functions) for the dumped databases in the output. This option requires the global SELECT  privilege. 

The output generated by using --routines  contains CREATE PROCEDURE  and CREATE FUNCTION statements to create the routines. 

This option is enabled by default; use --skip-routines  to disable it. 

• --server-public-key-path= file_name 

The path name to a file in PEM format containing a client-side copy of the public key required by the server for RSA key pair-based password exchange. This option applies to clients that authenticate with the sha256_password  or caching_sha2_password  authentication plugin. This option is ignored for accounts that do not authenticate with one of those plugins. 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 sha256_password , this option applies only if MySQL was built using OpenSSL. 

For information about the sha256_password  and caching_sha2_password  plugins, see Section 6.4.1.3, “SHA-256 Pluggable Authentication” , and Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . 

• --set-charset 

Write SET NAMES default_character_set  to the output. 

