User guide

ExtremeWare EPICenter Software Installation and User Guide E-5
The Backup Utility
This example assumes a database user ID of dba,withpasswordsql.Thesearethe
defaults used when the database server is installed through the EPICenter installation
process. If you have changed your database user ID and password, substitute your actual
user ID and password in the command.
<
install_dir> is the directory where the EPICenter software is installed. Substitute the
actualdirectory name in the command.
<
backup_dir> is the directory where the backup copy of the database should be stored.
Substitute an actual directory name in the command.
This command generates a backup of the database in the specified backup directory. The
backup consists of two files,
basecamp.db and basecamp.log. All database files are
backed up. These files should be saved so they can be used to replace the originalfiles in
the event of a problem.
Syntax:
dbbackup [switches] directory
Database Connection Parameters
Thesearetheparametersforthe-c command-lineswitch.Iftheconnectionparametersare
not specified, connection parameters from the SQLCONNECT environment variable are
used, if set.
Table E-3: dbbackup Command Switches
Switch Description
-c “keyword=value; ...” Supply database connection parameters
-y Replace files without confirmation
Table E-4: Database Connection Parameters for dbbackup Utility
uid=<user name>
Theusernameusedtologintothedatabase.Defaultisdba.The
user ID must have DBA authority.
pwd=<password> The password used to login to the database. Default is sql.
dbf=<database_file> The name of the file that stores the data. This is the file to be
backed up.