content_image/776766.jpg content_image/776767.jpg
mysqlpump  features include: 

•Parallel processing of databases, and of objects within databases, to speed up the dump process 

•Better control over which databases and database objects (tables, stored programs, user accounts) to dump 

•Dumping of user accounts as account-management statements ( CREATE USER , GRANT ) rather than as inserts into the mysql  system database 

•Capability of creating compressed output 

•Progress indicator (the values are estimates) 

•For dump file reloading, faster secondary index creation for InnoDB  tables by adding indexes after rows are inserted 

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

## Note 

mysqlpump  uses MySQL features introduced in MySQL 5.7, and thus assumes use with MySQL 5.7 or higher. 

mysqlpump  requires at least the SELECT  privilege for dumped tables, SHOW VIEW  for dumped views, TRIGGER  for dumped triggers, and LOCK TABLES  if the --single-transaction  option is not used. The SELECT  privilege on the mysql  system database is required to dump user definitions. Certain options might require other privileges as noted in the option descriptions. 

To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE  privileges for objects created by those statements. 

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

## Note 

A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding: 

mysqlpump [options] > dump.sql 

However, UTF-16 is not permitted as a connection character set (see Section 10.4, “Connection Character Sets and Collations” ), so the dump file cannot be loaded correctly. To work around this issue, use the --result-file  option, which creates the output in ASCII format: 

## mysqlpump Invocation Syntax 

mysqlpump [options] --result-file=dump.sql 

By default, mysqlpump  dumps all databases (with certain exceptions noted in mysqlpump Restrictions). To specify this behavior explicitly, use the --all-databases  option: 

mysqlpump --all-databases 

To dump a single database, or certain tables within that database, name the database on the command line, optionally followed by table names: 

mysqlpump db_name mysqlpump db_name tbl_name1 tbl_name2 ... 

To treat all name arguments as database names, use the --databases  option: 

mysqlpump --databases db_name1 db_name2  ... 

