| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
If you are new to Bahmni on Docker, we recommend you to go through the Getting Started documentation to try Bahmni with demo database on docker and get used to different configurations and commands before starting the migration. |
...
| Expand | ||
|---|---|---|
| ||
/bahmni-backup |--- bahmni_config |--- clinical_forms |--- dcm4chee_archive |--- dcm4cheedb_backup.sql |--- document_images |--- odoodb_backup.sql |--- openelisdb_backup.sql |--- openmrsdb_backup.sql |--- pacs_integrationdb_backup.sql |--- patient_images |--- reports |--- reportsdb_backup.sql |--- uploaded_results |--- uploaded-files |
Now you can compress the backup artifacts folder /bahmni-backup using zip or gzip and copy it to the new server over an external Hard drive or USB stick.
...
Few useful queries to validate the restore of OpenMRS database:
The below queries can be run inside OpenMRS db container by exec and connecting to MYSQL. (docker compose exec -it openmrsdb bash)
| Code Block |
|---|
--> List all tables (Approx 246 tables) SHOW tables; --> List all procedures in OpenMRS database. You will see entries showing names SHOW PROCEDURE STATUS WHERE db = 'openmrs'; --> List Routine Information in OpenMRS database SELECT routine_schema,routine_name,routine_type FROM information_schema.routines WHERE routine_schema = 'openmrs' ORDER BY routine_name; ---> Validate View Creation (You should see a query fetching information from concept related tables) select VIEW_DEFINITION from information_schema.views where TABLE_NAME='concept_view'; |
...
Tip for local, testing or pre-prod environments (Not on production)
If you at any time feel that something is not working as expected or you wish to start over gain, you can cleanup your environment by running docker compose --profile bahmni-standard down -v and then start off with the restore process from fresh again.
...