mysqlpump — A Database Backup Program --include-databases=%  is similar to  --all-databases , but selects all databases for dumping, even those that are exceptions for  --all-databases . •The  --databases  option causes  mysqlpump  to treat all name arguments as names of databases to dump. It is equivalent to an  --include-databases  option that names the same databases. mysqlpump Parallel Processing mysqlpump  can use parallelism to achieve concurrent processing. You can select concurrency between databases (to dump multiple databases simultaneously) and within databases (to dump multiple objects from a given database simultaneously). By default,  mysqlpump  sets up one queue with two threads. You can create additional queues and control the number of threads assigned to each one, including the default queue: The default queue always uses the default number of threads. Additional queues use the default number of threads unless you specify otherwise. Multiple instances of the  --parallel-schemas  option create multiple queues. Names in the database list are permitted to contain the same  %  and  _  wildcard characters supported for filtering options (see mysqlpump Object Selection). mysqlpump  uses the default queue for processing any databases not named explicitly with a  -- parallel-schemas  option, and for dumping user definitions if command options select them. In general, with multiple queues,  mysqlpump  uses parallelism between the sets of databases processed by the queues, to dump multiple databases simultaneously. For a queue that uses multiple threads, mysqlpump  uses parallelism within databases, to dump multiple objects from a given database simultaneously. Exceptions can occur; for example,  mysqlpump  may block queues while it obtains from the server lists of objects in databases. With parallelism enabled, it is possible for output from different databases to be interleaved. For example, INSERT  statements from multiple tables dumped in parallel can be interleaved; the statements are not written in any particular order. This does not affect reloading because output statements qualify object names with database names or are preceded by  USE  statements as required. The granularity for parallelism is a single database object. For example, a single table cannot be dumped in parallel using multiple threads. Examples: mysqlpump --parallel-schemas=db1,db2 --parallel-schemas=db3 mysqlpump  sets up a queue to process  db1  and  db2 , another queue to process  db3 , and a default queue to process all other databases. All queues use two threads. mysqlpump --parallel-schemas=db1,db2 --parallel-schemas=db3 --default-parallelism=4 530 • --parallel-schemas=[ N :] db_list  sets up a processing queue for dumping the databases named in  db_list  and optionally specifies how many threads the queue uses.  db_list  is a list of comma- separated database names. If the option argument begins with  N : , the queue uses  N  threads. Otherwise, the  --default-parallelism  option determines the number of queue threads. • --default-parallelism= N  specifies the default number of threads used for each queue. In the absence of this option,  N  is 2.