Owner's Manual

138 Database Management
• You can add as many entries as you like. However, you can use initial, max and
autoextend only in the last entry, and must change the first entry to reflect the actual size
of the database.
• The name of filepath must be valid on the filesystems. However, you must always have your
leaf directory in the path as ibdata.
Database Backup / Restoration
The recommended procedures for database backup and restoration for the embedded database
follows. Best practice is to develop backup plans using these procedures for the sake of database
reliability.
For MySQL (embedded) databases, use this database’s native backup/restore utilities, described in
the following section, to backup the
owbusdb database. Refer to the manual available at
dev.mysql.com/downloads/mysql/5.0.html for instructions about backup and restoration.
MySQL Backup / Restore
Follow these instructions to back up and restore the embedded Mysql database using native
MySQL utilities on a command line. Default MySQL Backup and Default MySQL Restoration
describe this process within this application:
Backup
Open a command shell ( Start -> Run cmd , in Windows), and then type the following at the
prompt replacing USERNAME and DATABASE. By default, the databases are
owbusdb and
owmetadb .
mysqldump -a -u USERNAME --password=[name] DATABASE > FILENAME.mysql
This writes the DATABASE to a plain-text file called FILENAME.mysql . 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).
Restoring
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 DATABASE
or
mysqadmin -u USERNAME --password=[password] drop DATABASE
NOTE:
Red Hat Linux requires rm -rf owmetadb to drop this database.