Make sure bahmni-backup has a folder named bahmni_config and a backup file named openmrsdb_backup.sql
Two Step Restore:
Note: To perform the upgrade, we need our instance to be running on MySQL 8 to take advantage of the enhanced security features. But to do that, we need to start with restoring our backup to MySQL 5.7 since it was running on 5.7.30 on eRegister 0.92.
Let the restore run for a while. It's going to take some time, obviously, with varying ETAs based on the size of the DB.
After the backup has been restored, log in to the system and test that you can search for a client on the Registration module.
Then stop your instance and change the image to MySQL 8
cd ~/v1/openmrs/bahmni-docker-ls/bahmni-standard
Edit the .env to OPENMRS_DB_IMAGE_NAME=mysql:5.7 and REPORTS_DB_IMAGE_NAME=mysql:5.7
Run ./restore_bahmni_standard.sh /home/openmrs/v1/bahmni-backup
./run-bahmni.sh
After testing that the restore went well, you can shut down the instance by running ./run-bahmni.sh and choosing option (2)
Edit the .env to OPENMRS_DB_IMAGE_NAME=mysql:8.0 and REPORTS_DB_IMAGE_NAME=mysql:8.0