Owner's Manual

Database Management 139
2 Recreate the database
mysqladmin -u USERNAME -p create DATABASE
or
mysqadmin -u USERNAME --password=[password] create DATABASE
3 Import the backup data
mysql -u USERNAME -p DATABASE < FILENAME.mysql
or
mysql -u USERNAME --password=[password] DATABASE < FILENAME.mysql
Default MySQL Backup
The following command lines back up owbusbd and owmetadb to a file. The following also
assumes you have run the
oware command in the shell, and have changed directories to
owareapps/db_backup .
mysqldump -a -u oware --password=dorado owbusdb > owbusdb.mysql
mysqldump -a -u oware --password=dorado owmetadb > owmetadb.mysql
Note that this example uses the default user name ( oware ), default password ( dorado ), and
backs up both the
owbusdb and owmetadb databases.
Default MySQL Restoration
Restoration is the three-step process outlined above:
1 Remove existing database
mysqladmin -u oware --password=dorado drop owmetadb
mysqladmin -u oware --password=dorado drop owbusdb
2 Create a new database
mysqladmin -u oware --password=dorado create owmetadb
mysqladmin -u oware --password=dorado create owbusdb
3 Import the data previously backed up.
mysql -u oware --password=dorado owmetadb < owmetadb.mysql
mysql -u oware --password=dorado owbusdb < owbusdb.mysql