content_image/665896.jpg
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. 

• --lines-terminated-by=... 

This option is used with the --tab  option and has the same meaning as the corresponding LINES clause for LOAD DATA . See Section 13.2.7, “LOAD DATA Statement” . 

• --quote-names , -Q 

Quote identifiers (such as database, table, and column names) within ‘  characters. If the ANSI_QUOTES SQL mode is enabled, identifiers are quoted within "  characters. This option is enabled by default. It can be disabled with --skip-quote-names , but this option should be given after any option such as -- compatible  that may enable --quote-names . 

• --result-file= file_name , -r 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. 

• --show-create-skip-secondary-engine= value 

Excludes the SECONDARY ENGINE  clause from CREATE TABLE  statements. It does so by enabling the show_create_table_skip_secondary_engine  system variable for the duration of the dump operation. Alternatively, you can enable the show_create_table_skip_secondary_engine  system variable prior to using mysqldump . 

This option was added in MySQL 8.0.18. Attempting a mysqldump  operation with the --show- create-skip-secondary-engine  option on a release prior to MySQL 8.0.18 that does not support the show_create_table_skip_secondary_engine  variable causes an error. 

• --tab= dir_name , -T dir_name 

Produce tab-separated text-format data files. For each dumped table, mysqldump  creates a tbl_name .sql  file that contains the CREATE TABLE  statement that creates the table, and the server writes a tbl_name .txt  file that contains its data. The option value is the directory in which to write the files. 

<img src='content_image/665896.jpg'>

## Note 

This option should be used only when mysqldump  is run on the same machine as the mysqld  server. Because the server creates *.txt  files in the directory that you specify, the directory must be writable by the server and the MySQL account that you use must have the FILE  privilege. Because mysqldump  creates *.sql  in the same directory, it must be writable by your system login account. 

By default, the .txt  data files are formatted using tab characters between column values and a newline at the end of each line. The format can be specified explicitly using the --fields- xxx  and --lines- terminated-by  options. 

Column values are converted to the character set specified by the --default-character-set option. 

