Deployment Guide

Maintenance

This chapter describes how to take a backup of the database.

Database backup

Stop Tomcat Service before taking a backup of the database. Tomcat Service is identified as “Dell WMS: Tomcat Service” and must be

stopped from Local Services.

To dump the contents of the MongoDB, run the following command:

mongodump --host <mongodb_host> -u stratus –p <db_password> --authenticationDatabase admin --db

stratus --out ".\wmsmongodump"

To dump the contents of the MarioDB, run the following command:

mysqldump --routine –h<mariadb_host> -ustratus –p<db_password> stratus > ".\wmsdump.sql"

Database restore

Stop Tomcat Service before restoring the database. Tomcat Service is identified as “Dell WMS: Tomcat Service” and can be stopped from

Local Services.

• You must run the following command from the wmsmongodump directory – parent directory of stratus database, to restore

MongoDB.

• echo "db.dropDatabase()" | mongo -u stratus -p <db_password> --authenticationDatabase admin

--host <db_host> stratus

• mongorestore --host <db_host> -u stratus -p <db_password> --authenticationDatabase admin --

db stratus ".\stratus"

• You must run the following command from the wmsdump.sql directory to restore MariaDB.

• Mysql.exe --verbose -h<mariadb_host> -ustratus -p<db_password> -e "DROP DATABASE stratus"

• Mysql.exe --verbose -h<mariadb_host> -ustratus -p<db_password> -e "CREATE DATABASE stratus

DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci"

• Mysql.exe --verbose -h<mariadb_host> -ustratus -p<db_password> stratus < ".\wmsdump.sql"

Maintenance 21