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.

Defaults for the database are oware (login) and dorado (password). These are typically different from the login / password for the application.

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