content_image/813797.jpg content_image/813810.jpg
## mysqlpump Option Descriptions 

• --help , -? 

Display a help message and exit. 

• --add-drop-database 

Write a DROP DATABASE  statement before each CREATE DATABASE  statement. 

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

• --add-drop-table 

Write a DROP TABLE  statement before each CREATE TABLE  statement. 

• --add-drop-user 

Write a DROP USER  statement before each CREATE USER  statement. 

• --add-locks 

## Note 

In MySQL 8.0, the mysql  schema is considered a system schema that cannot be dropped by end users. If --add-drop-database  is used with --all- databases  or with --databases  where the list of schemas to be dumped includes mysql , the dump file contains a DROP DATABASE ‘mysql‘  statement that causes an error when the dump file is reloaded. 

Instead, to use --add-drop-database , use --databases  with a list of schemas to be dumped, where the list does not include mysql . 

Surround each table dump with LOCK TABLES  and UNLOCK TABLES  statements. This results in faster inserts when the dump file is reloaded. See Section 8.2.5.1, “Optimizing INSERT Statements” . 

This option does not work with parallelism because INSERT  statements from different tables can be interleaved and UNLOCK TABLES  following the end of the inserts for one table could release locks on tables for which inserts remain. 

--add-locks  and --single-transaction  are mutually exclusive. 

• --all-databases , -A 

Dump all databases (with certain exceptions noted in mysqlpump Restrictions). This is the default behavior if no other is specified explicitly. 

--all-databases  and --databases  are mutually exclusive. 

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

## Note 

See the --add-drop-database  description for information about an incompatibility of that option with --all-databases . 

Prior to MySQL 8.0, the --routines  and --events  options for mysqldump  and mysqlpump  were not required to include stored routines and events when using the --all-databases  option: The dump included the mysql  system database, and therefore also the mysql.proc  and mysql.event  tables containing stored routine and event definitions. As of MySQL 8.0, the mysql.event  and mysql.proc tables are not used. Definitions for the corresponding objects are stored in data dictionary tables, but 

