Extreme Networks EPICenter 6.0, Reference Manual

Page: 540 / 580

EPICenter Backup
EPICenter Reference Guide
540
<
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 original files in the event of a problem.
NOTE
Do not stop the EPICenter server to perform daily backups of the database. This action is not necessary and will
prevent the alarm and event logs from truncating.
Syntax: dbbackup [switches] directory
Database Connection Parameters
These are the parameters for the
-c
command-line switch. If the connection parameters are not
specified, connection parameters from the SQLCONNECT environment variable are used, if set.
The connection parameters are separated by semicolons, and the entire set must be quoted. For
example, under Windows, the following backs up the EPICenter database basecamp.db, connecting as
user ID
dba
with password
sql
:
<install_dir> \database\dbbackup -c
“uid=dba;pwd=sql;eng=EPIC51;dbf= <install_dir >\basecamp.db” c:\tmp
Installing a Backup Database
The backup database is named
basecamp.db
, and is kept in the directory you specified when you ran
the
dbbackup
command (
c:\tmp
in the example).
To replace a damaged database with the backup copy, follow these steps:
1 Shut down the EPICenter software following the instructions for your operating system in the
EPICenter Installation and Upgrade Note .
2 Move or delete the old copy of
basecamp.db
and
basecamp.log
found in the EPICenter installation
directory.
Table 63: dbbackup Command Switches
Switch Description
-c “keyword=value; ...” Supply database connection parameters
-y Replace files without confirmation
Table 64: Database Connection Parameters for dbbackup Utility
uid=
<user name> The user name used to login to the database. Default is dba. 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.
eng=EPIC51 The name of the database engine. This value must be EPIC51 for EPICenter 6.0.