• --triggers 

Include triggers for each dumped table in the output. 

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

• --tz-utc 

This option enables TIMESTAMP  columns to be dumped and reloaded between servers in different time zones. mysqlpump  sets its connection time zone to UTC and adds SET TIME_ZONE=’+00:00’  to the dump file. Without this option, TIMESTAMP  columns are dumped and reloaded in the time zones local to the source and destination servers, which can cause the values to change if the servers are in different time zones. --tz-utc  also protects against changes due to daylight saving time. 

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

• --user= user_name , -u user_name 

The user name of the MySQL account to use for connecting to the server. 

• --users 

Dump user accounts as logical definitions in the form of CREATE USER  and GRANT  statements. 

User definitions are stored in the grant tables in the mysql  system database. By default, mysqlpump does not include the grant tables in mysql  database dumps. To dump the contents of the grant tables as logical definitions, use the --users  option and suppress all database dumping: 

mysqlpump --exclude-databases=% --users 

• --version , -V 

Display version information and exit. 

• --watch-progress 

Periodically display a progress indicator that provides information about the completed and total number of tables, rows, and other objects. 

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

• --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. 

## mysqlpump Object Selection 

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

This option was added in MySQL 8.0.18. 

mysqlpump  has a set of inclusion and exclusion options that enable filtering of several object types and provide flexible control over which objects to dump: 

• --include-databases  and --exclude-databases  apply to databases and all objects within them. 

