Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

dump

Generates a sequence of SQL statements that can be executed to reproduce the objects defined in the cluster.

Usage

Generates a sequence of SQL statements that can be executed to reproduce the objects defined in the cluster.

Available object types are (all object types are dumped by default): 
	users, roles, groups, resource-pools, databases, tables, views, procedures, functions, aggregates, and pipelines
           
When --databases flag is used, databases, tables, views, procedures, functions, aggregates, and pipelines will only be dumped for the specified databases.
            
Examples:
            
	sdb-admin dump --exclude users,roles,groups --output-path dump.sql
            
	sdb-admin dump --only databases,tables,procedures --databases db1,db2

Usage:
  sdb-admin dump [flags]

Flags:
      --databases VALUES            Only run for specified databases
      --exclude VALUES              Exclude the specified objects
  -h, --help                        Help for dump
      --only VALUES                 Only dump specified objects
      --output-path ABSOLUTE_PATH   Write the dump file to this path

Global Flags:
      --backup-cache FILE_PATH              File path for the backup cache
      --cache-file FILE_PATH                File path for the Toolbox node cache
  -c, --config FILE_PATH                    File path for the Toolbox configuration
      --disable-colors                      Disable colored output in console, which some terminal sessions/environments may have issues with
      --disable-spinner                     Disable the progress spinner, which some terminal sessions/environments may have issues with
  -j, --json                                Enable JSON output
      --parallelism POSITIVE_INTEGER        Maximum number of operations to run in parallel
      --runtime-dir DIRECTORY_PATH          Where to store Toolbox runtime data
      --ssh-max-sessions POSITIVE_INTEGER   Maximum number of SSH sessions to open per host, must be at least 3
      --state-file FILE_PATH                Toolbox state file path
  -v, --verbosity count                     Increase logging verbosity: valid values are 1, 2, 3. Usage -v=count or --verbosity=count
  -y, --yes                                 Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default

Remarks

This command is interactive unless you use either the --yes or --json flags to override interactive behavior.