mysqlpump — A Database Backup Program • --include-tables  and  --exclude-tables  apply to tables. These options also affect triggers associated with tables unless the trigger-specific options are given. • --include-triggers  and  --exclude-triggers  apply to triggers. • --include-routines  and  --exclude-routines  apply to stored procedures and functions. If a routine option matches a stored procedure name, it also matches a stored function of the same name. • --include-events  and  --exclude-events  apply to Event Scheduler events. • --include-users  and  --exclude-users  apply to user accounts. • %  matches any sequence of zero or more characters. • _  matches any single character. •By default, with no inclusion or exclusion options,  mysqlpump  dumps all databases (with certain exceptions noted in mysqlpump Restrictions). •If inclusion options are given in the absence of exclusion options, only the objects named as included are dumped. •If exclusion options are given in the absence of inclusion options, all objects are dumped except those named as excluded. •If inclusion and exclusion options are given, all objects named as excluded and not named as included are not dumped. All other objects are dumped. •The  --all-databases  option dumps all databases (with certain exceptions noted in mysqlpump Restrictions). It is equivalent to specifying no object options at all (the default  mysqlpump  action is to dump everything). Any inclusion or exclusion option may be given multiple times. The effect is additive. Order of these options does not matter. The value of each inclusion and exclusion option is a list of comma-separated names of the appropriate object type. For example: Wildcard characters are permitted in the object names: For example,  --include-tables=t%,__tmp  matches all table names that begin with  t  and all five- character table names that end with  tmp . For users, a name specified without a host part is interpreted with an implied host of  % . For example,  u1 and  u1@%  are equivalent. This is the same equivalence that applies in MySQL generally (see Section 6.2.4, “Specifying Account Names” ). Inclusion and exclusion options interact as follows: If multiple databases are being dumped, it is possible to name tables, triggers, and routines in a specific database by qualifying the object names with the database name. The following command dumps databases  db1  and  db2 , but excludes tables  db1.t1  and  db2.t2 : The following options provide alternative ways to specify which databases to dump: 529 --exclude-databases=test,world --include-tables=customer,invoice mysqlpump --include-databases=db1,db2 --exclude-tables=db1.t1,db2.t2