Dell OpenManage Network Manager, Client Manual

Page: 61 / 388

Redcell > Database Aging Policies (DAP) | Getting Started with Dell OpenManage Network Manager
61
10
Log out as admin, and log back in as a user with Gold Customer permissions.
11
Confirm your permission configuration is operating on this page.
Database Backup
To back up your database, open a command shell ( Start > Run
cmd
, in Windows), and then type
the following at the prompt replacing USERNAME and owbusdb. By default, the database is
owbusdb
.
mysqldump -a -u USERNAME --password=[name] owbusdb > FILENAME.mysql
For example:
mysqldump -a -u oware --password=dorado owmetadb > owmetadb.mysql
If you have Performance monitors or Traffic Analyzer, you must also back up your stored procedures
otherwise they do not get restored when you restore the database. The command line here adds
--
routines
. For example:
mysqldump -a -u oware --password=dorado --routines owbusdb > owbusdb.mysql
This writes the owbusdb to a plain-text file called
FILENAME.mysql
(
owbusdb.mysql
in our
examples). This file is a full backup with which you can fully restore your database in case of
problems.
NOTE:
Defaults for the database are oware (login) and dorado (password). These are typically different from the
login / password for the application.
Tip
To get a rough estimate of database size, looking at the size of the directory
\oware3rd\mysql\data.
Restoring Databases
Restoring from
FILENAME.mysql
is a three step process. This occurs, again, in a command shell:
1
Drop the database:
mysqladmin -u USERNAME -p drop owbusdb
or
mysqadmin -u USERNAME --password=[password] drop owbusdb
2
Recreate the database
mysqladmin -u USERNAME -p create owbusdb
or
mysqadmin -u USERNAME --password=[password] create owbusdb
3
Import the backup data