Users Guide

Upgrading an Existing Installation | Installing Single-Server Deployment
OMNM 6.5.3 Installation Guide 41
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 [installation
root]
\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
Restoring Databases
Restore your MySQL database from the filename .mysql file from the command line as follows.
1 Drop the database using one of the following commands:
mysqladmin -u USERNAME -p drop owbusdb
mysqladmin -u USERNAME --password=[password] drop owbusdb
2 Recreate the database using one of the following commands:
mysqladmin -u USERNAME -p create owbusdb
mysqladmin -u USERNAME --password=[password] create owbusdb
3 Import the backup data using one of the following commands:
mysql -u USERNAME -p owbusdb < FILENAME.mysql
mysql -u USERNAME --password=[password] owbusdb < FILENAME.mysql
Here are restoration commands for all the databases:
mysql -u root --password=dorado owmetadb < owmetadb.mysql
mysql -u root --password=dorado owbusdb < owbusdb.mysql
mysql -u root --password=dorado lportal < lportal.mysql
mysql -u root --password=dorado synergy < synergy.mysql
Whenever you upgrade your system and your database is on a separate server, you must run the
dbpostinstall script on the (primary) Application server too.
Upgrading on Windows
This section provides the steps for preparing your Windows system for an upgrade and then
running the installer .
Preparing to Upgrade on Windows
As with a standard install, make sure that you can communicate with the network.
If the Application server automatically starts during installation, the Web and Application servers
start as a service. Programs that run as a service
do not trigger a Windows Firewall notification that
allows you to grant firewall access to the program. Additionally, MySQL always runs as a service.