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"
8
24 Maintenance