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.
...
- 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.
...