NetBackup™ Commands Reference Guide
- Introduction
- Appendix A. NetBackup Commands
Name
nbdb_unload — unload the NetBackup databases
SYNOPSIS
[-dbn database_name] [-t tablelist] [-s] destination directory
[-dbn database_name] -rebuild [-verbose]
On UNIX systems, the directory path to this command is /usr/openv/db/bin/
On Windows systems, the directory path to this command is install_path\NetBackup\bin\
DESCRIPTION
The nbdb_unload command unloads the specified database. By default the NBDB database is unloaded. The other value for -dbn includes BMRDB (Bare Metal Restore database) or NBAZDB (the Authorization database).
Note:
The Enterprise Media Manager (EMM) database is a component of the NBDB database.
The nbdb_unload command generates a single file with name database_name.sql
that contains the schema and data. For the NBDB database, the schema and data are unloaded as a file that is named NBDB.sql
in the named directory. For other databases, a similar file is created. For example, for BMRDB the file is BMRDB.sql
. For NBAZDB the file is NBAZDB.sql
.
OPTIONS
- -dbn database_name
Specifies the database that is to be unloaded.
The values are NBDB, NBAZDB, and BMRDB. If -dbn is not provided, the default is NBDB.
- -rebuild
Rebuilds the default NetBackup database (NBDB).
- -s
Unloads the schema only - no data is unloaded.
- -t tablelist
Specifies a comma-separated list of tables to unload instead of all the tables in the database. The tables must be in the format schema_name.table_name.
- -verbose
Generates more detailed information for the output.
- destination directory
Specifies the directory where the user wants the dump of the data and schema. The destination_directory must exist and any files of the same name are overwritten. On Linux, the database user must have access to the destination_directory.
EXAMPLES
Example 1 - Unload the NBDB database (including all of EMM), data and schema:
UNIX systems: # nbdb_unload /tmp/nbdb_dump
Windows systems: # nbdb_unload C:\temp\nbdb_dump
Example 2 - Unload only the NBDB schema:
UNIX systems: # nbdb_unload -s /tmp/nbdb_dump
Windows systems: # nbdb_unload -s C:\temp\nbdb_dump
Example 3 - Unload only the EMM_STU table (by using fully qualified table names):
UNIX systems: # nbdb_unload -t emm_main.emm_stu /tmp/stu
Windows systems: # nbdb_unload -t emm_main.emm_stu C:\temp\stu
Example 4 - Unload the BMR database:
UNIX systems: # nbdb_unload -dbn BMRDB /tmp/bmr_dump
Windows systems: # nbdb_unload -dbn BMRDB C:\temp\bmr_dump