Please note that while restoring the database you also need to restore the os-data directory. The state of the app is not just database, it is a combination of (database + data directory i.e. os-data directory). So both need to be restored to the same date.

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 a database with a new name using create database [new_os].
Assign proper privileges to the openspecimen user to connect to this new database.
Open command prompt/terminal.
Restore the backup using mysql -u [openspecimen] -p[xxxx] [new_os] < [older_back_file_name.sql].
Restore the os-data folder to the same date as of the database backup.
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.

Oracle:

Stop the OpenSpecimen service.
Connect to Oracle using sqlplus / as sysdba.
Create a user with a new name using create user [new_os] identified by [new password].
Grant proper privileges to the newly created user [new_os] to connect to this new database.
Open command prompt/terminal
Restore the backup using impdp <username>/<password> DIRECTORY=<DUMP_DIR> DUMPFILE=<older_back_file_name.sql> REMAP_SCHEMA=<from_user>:<to_user> logfile=<logfile.log> transform=oid:n
Restore the os-data folder to the same date as of the database backup.
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.