content_image/703870.jpg
By default, mysqlpump  does not dump user account definitions, even if you dump the mysql  system database that contains the grant tables. To dump grant table contents as logical definitions in the form of CREATE USER  and GRANT  statements, use the --users  option and suppress all database dumping: 

mysqlpump --exclude-databases=% --users 

In the preceding command, %  is a wildcard that matches all database names for the --exclude- databases  option. 

mysqlpump  supports several options for including or excluding databases, tables, stored programs, and user definitions. See mysqlpump Object Selection. 

To reload a dump file, execute the statements that it contains. For example, use the mysql  client: 

mysqlpump [options] > dump.sql mysql < dump.sql 

The following discussion provides additional mysqlpump  usage examples. 

To see a list of the options mysqlpump  supports, issue the command mysqlpump --help . 

## mysqlpump Option Summary 

mysqlpump  supports the following options, which can be specified on the command line or in the [mysqlpump]  and [client]  groups of an option file. (Prior to MySQL 8.0.20, mysqlpump  read the [mysql_dump]  group rather than [mysqlpump] . As of 8.0.20, [mysql_dump]  is still accepted but is deprecated.) For information about option files used by MySQL programs, see Section 4.2.2.2, “Using Option Files” . 

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

