mysqlshow — Display Database, Table, and Column Information This is the same as the previous example except that all queues use four threads. mysqlpump --parallel-schemas=5:db1,db2 --parallel-schemas=3:db3 The queue for  db1  and  db2  uses five threads, the queue for  db3  uses three threads, and the default queue uses the default of two threads. As a special case, with  --default-parallelism=0  and no  --parallel-schemas  options, mysqlpump  runs as a single-threaded process and creates no queues. mysqlpump  does not dump the  performance_schema ,  ndbinfo , or  sys  schema by default. To dump any of these, name them explicitly on the command line. You can also name them with the  --databases or  --include-databases  option. mysqlpump  does not dump the  INFORMATION_SCHEMA  schema. mysqlpump  does not dump  InnoDB CREATE TABLESPACE  statements. mysqlpump  dumps user accounts in logical form using  CREATE USER  and  GRANT  statements (for example, when you use the  --include-users  or  --users  option). For this reason, dumps of the mysql  system database do not by default include the grant tables that contain user definitions:  user , db ,  tables_priv ,  columns_priv ,  procs_priv , or  proxies_priv . To dump any of the grant tables, name the  mysql  database followed by the table names: mysqlpump mysql user db ... The  mysqlshow  client can be used to quickly see which databases exist, their tables, or a table’s columns or indexes. mysqlshow  provides a command-line interface to several SQL  SHOW  statements. See Section 13.7.7, “SHOW Statements” . The same information can be obtained by using those statements directly. For example, you can issue them from the  mysql  client program. Invoke  mysqlshow  like this: mysqlshow [ options ] [ db_name  [ tbl_name  [ col_name ]]] •If no database is given, a list of database names is shown. •If no table is given, all matching tables in the database are shown. •If no column is given, all matching columns and column types in the table are shown. The output displays only the names of those databases, tables, or columns for which you have some privileges. If the last argument contains shell or SQL wildcard characters ( * ,  ? ,  % , or  _ ), only those names that are matched by the wildcard are shown. If a database name contains any underscores, those should be escaped with a backslash (some Unix shells require two) to get a list of the proper tables or columns.  * and  ?  characters are converted into SQL  %  and  _  wildcard characters. This might cause some confusion when you try to display the columns for a table with a  _  in the name, because in this case,  mysqlshow shows you only the table names that match the pattern. This is easily fixed by adding an extra  %  last on the command line as a separate argument. 531 4.5.7 mysqlshow — Display Database, Table, and Column Information mysqlpump Restrictions