content_image/853136.jpg
• --write-binlog 

This option is enabled by default, so that ANALYZE TABLE , OPTIMIZE TABLE , and REPAIR TABLE statements generated by mysqlcheck  are written to the binary log. Use --skip-write-binlog  to cause NO_WRITE_TO_BINLOG  to be added to the statements so that they are not logged. Use the -- skip-write-binlog  when these statements should not be sent to replicas or run when using the binary logs for recovery from backup. 

• --zstd-compression-level= level 

The compression level to use for connections to the server that use the zstd  compression algorithm. The permitted levels are from 1 to 22, with larger values indicating increasing levels of compression. The default zstd  compression level is 3. The compression level setting has no effect on connections that do not use zstd  compression. 

## 4.5.4 mysqldump — A Database Backup Program 

For more information, see Section 4.2.8, “Connection Compression Control” . 

This option was added in MySQL 8.0.18. 

The mysqldump  client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump  command can also generate output in CSV, other delimited text, or XML format. 

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

•Performance and Scalability Considerations 

•Invocation Syntax 

•Option Syntax - Alphabetical Summary 

•Connection Options 

•Option-File Options 

•DDL Options 

•Debug Options 

•Help Options 

•Internationalization Options 

•Replication Options 

•Format Options 

•Filtering Options 

## Tip 

Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL Database Service compatibility checks and modifications. Dumps can be easily imported into a MySQL Server instance or a MySQL Database Service DB System using the MySQL Shell load dump utilities. Installation instructions for MySQL Shell can be found here. 

