mysqlpump — A Database Backup Program mysqlpump Option Descriptions • --help ,  -? • --add-drop-database Display a help message and exit. Write a  DROP DATABASE  statement before each  CREATE DATABASE  statement. 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 . Write a  DROP TABLE  statement before each  CREATE TABLE  statement. • --add-drop-table • --add-drop-user • --add-locks Write a  DROP USER  statement before each  CREATE USER  statement. 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. 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 518