mysqlpump — A Database Backup Program mysqlpump  features include: 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. A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding: 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: By default,  mysqlpump  dumps all databases (with certain exceptions noted in mysqlpump Restrictions). To specify this behavior explicitly, use the  --all-databases  option: To dump a single database, or certain tables within that database, name the database on the command line, optionally followed by table names: To treat all name arguments as database names, use the  --databases  option: 512 mysqlpump  db_name mysqlpump  db_name tbl_name1 tbl_name2 ... mysqlpump --all-databases mysqlpump --databases  db_name1 db_name2  ... mysqlpump Invocation Syntax mysqlpump [options] > dump.sql mysqlpump [options] --result-file=dump.sql Note Note •For dump file reloading, faster secondary index creation for  InnoDB  tables by adding indexes after rows are inserted •Progress indicator (the values are estimates) •Capability of creating compressed output •Dumping of user accounts as account-management statements ( CREATE USER ,  GRANT ) rather than as inserts into the  mysql  system database •Better control over which databases and database objects (tables, stored programs, user accounts) to dump •Parallel processing of databases, and of objects within databases, to speed up the dump process