mysqldump — A Database Backup Program • --write-binlog • --zstd-compression-level= level •Performance and Scalability Considerations •Invocation Syntax •Option Syntax - Alphabetical Summary •Connection Options •Option-File Options •DDL Options •Debug Options •Help Options •Replication Options •Internationalization Options •Format Options •Filtering Options 472 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. 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. This option was added in MySQL 8.0.18. For more information, see Section 4.2.8, “Connection Compression Control” . 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. 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. 4.5.4 mysqldump — A Database Backup Program Tip