Exporting database schema and data
Use the NetBackup Database Administration utility to unload either the schema or the schema and data from the NetBackup database.
To export database schema and data
- Start the NetBackup Database Administration utility and enter the database logon password. Click OK
- Select the Tools tab.
- In the Unload section, click Export.
- Browse to a destination directory.
- Select one or more of the following options:
Schema
Unload only the database schema. The schema is unloaded as a file that is named database.sql in the named directory. For the NBDB database, the schema is unloaded as a file that is named
NBDB.sqlin the named directory. For other databases, a similar file is created. For example, for BMRDB the file isBMRDB.sql. For NBAZDB the file isNBAZDB.sql.Schema and data
Unload both the database schema and the data. The data is unloaded as a set of files in comma-delimited format. One file is created for each database table.
- Click OK.