mysqlpump — A Database Backup Program 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: 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: The following discussion provides additional  mysqlpump  usage examples. To see a list of the options  mysqlpump  supports, issue the command  mysqlpump --help . 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” . Table 4.16 mysqlpump Options mysqlpump Option Summary mysqlpump --exclude-databases=% --users mysqlpump [options] > dump.sql mysql < dump.sql 513 Option Name Description Introduced Deprecated --add-drop-database Add DROP DATABASE statement before each CREATE DATABASE statement --add-drop-table Add DROP TABLE statement before each CREATE TABLE statement --add-drop-user Add DROP USER statement before each CREATE USER statement --add-locks Surround each table dump with LOCK TABLES and UNLOCK TABLES statements --all-databases Dump all databases --bind-address Use specified network interface to connect to MySQL Server --character-sets-dir Directory where character sets are installed