Owners Manual

Backing Up the Database | Getting Started
OMNM 6.5.2 User Guide 75
Backing Up the Database
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 , user name is root and password is dorado .
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 Flow 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.
Defaults for the database are
oware (login) and dorado (password). These are typically different
from the login/password for the application.
NOTE:
To get a rough estimate of a database’s size, looking at the size of the directory
\oware3rd\mysql\data.
Here are the backup commands for all the databases:
mysqldump -a -u root --password=dorado owbusdb > owbusdb.mysql
mysqldump -a -u root --password=dorado owmetadb > owmetadb.mysql
mysqldump -a -u root --password=dorado lportal > lportal.mysql
mysqldump -a -u root --password=dorado synergy > synergy.mysql
To backup stored procedures too:
mysqldump -a -u oware --password=dorado --routines owbusdb > owbusdb.mysql