Please follow the below steps to restore OpenSpecimen data from the backup:
MySQL:
- Stop the OpenSpecimen service
- Connect to MySQL using root as mysql -uroot -p[xxxx]
- Create database with new name using create database [new_os]
- Assign proper privileges to the openspecimen user to connect to this new database
- Open the command prompt
- Restore the backup using mysql -u [osadmin] -p[xxxx] [new_os] < [older_back_file_name.sql]
- Update the new database name in tomcat/conf/context.xml
- Start the OpenSpecimen service
- Once everything is fine, please update the backup script to point to the newly created database.