{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"This page documents how to take a DB Backup of your OpenMRS / EMR DB from ","type":"text"},{"text":"Kubernetes","type":"text","marks":[{"type":"strong"}]},{"text":" environment (running on cloud), build a ","type":"text"},{"text":"docker","type":"text","marks":[{"type":"strong"}]},{"text":" image with this DB, and then run Bahmni docker compose with the restored database. ","type":"text"}]},{"type":"paragraph","content":[{"text":"WARNING: ","type":"text","marks":[{"type":"strong"}]},{"text":"If you are working with production data, please be very careful how you handle it, who has access to it, and where you share/keep it. It is illegal to make private patient data available to people without authorisation in most countries!","type":"text","marks":[{"type":"em"}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"014ea497-53c1-4348-81c9-b06f70a14493"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"4efec85b-3a05-4d25-a298-f7c7945d4305"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Repositories","type":"text"}]},{"type":"paragraph","content":[{"text":"🔸 ","type":"text"},{"text":"Bahmni Lite","type":"text","marks":[{"type":"link","attrs":{"href":"https://github.com/Bahmni/bahmni-docker.git"}}]}]},{"type":"paragraph","content":[{"text":"🔸 ","type":"text"},{"text":"Bahmni Lite - India based with ABDM integration","type":"text","marks":[{"type":"link","attrs":{"href":"https://github.com/BahmniIndiaDistro/bahmni-india-package.git"}}]}]},{"type":"paragraph","content":[{"text":"🔸 ","type":"text"},{"text":"Bahmni Scripts - to build DB for openMRS ","type":"text","marks":[{"type":"link","attrs":{"href":"https://github.com/Bahmni/bahmni-scripts.git"}}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Setup","type":"text"}]},{"type":"paragraph","content":[{"text":"🔹 ","type":"text"},{"text":"Git","type":"text","marks":[{"type":"link","attrs":{"href":"https://git-scm.com/book/en/v2/Getting-Started-Installing-Git"}}]},{"text":" clone the respective Bahmni Lite repository","type":"text"}]},{"type":"paragraph","content":[{"text":"🔹 ","type":"text"},{"text":"Git","type":"text","marks":[{"type":"link","attrs":{"href":"https://git-scm.com/book/en/v2/Getting-Started-Installing-Git"}}]},{"text":" clone the Bahmni Scripts repository","type":"text"}]},{"type":"paragraph","content":[{"text":"🔹 Install ","type":"text"},{"text":"Docker","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/BAH/pages/299630726"}}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"DB backup from Kubernetes/AWS","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"We ran Bahmni Lite on AWS/Kubernetes. So the following setup will extract DB dump based on Kubernetes commands. ","type":"text"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get into the openMRS kubernetes pod","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"kubectl exec -it openmrs -n -- bash","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"2. Navigate to the ","type":"text"},{"text":"openmrs/data","type":"text","marks":[{"type":"code"}]},{"text":" folder and zip the ","type":"text"},{"text":"configuration_checksum","type":"text","marks":[{"type":"code"}]},{"text":" folder (which is used by Initializer module to determine if an initializer entry has run or not run).","type":"text"}]},{"type":"codeBlock","content":[{"text":"# install zip\nyum install zip\n\n# Navigate to openmrs/data directory\ncd /openmrs/data\n\n# Zip the checksums folder\nzip -r configuration_checksums.zip configuration_checksums","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"3. Backup the DB as a SQL dump","type":"text"}]},{"type":"codeBlock","content":[{"text":"# Install mysql cli\nyum install mysql\n\n# Export the current live DB as a sql dump to the pod\nmysql -u username -p database_name > omrsdb.sql\n# Provide password and press Enter\n\n# Exit Mysql\nExit","type":"text"}]},{"type":"paragraph","content":[{"text":"4. Note down the Database details","type":"text"}]},{"type":"codeBlock","content":[{"text":"# Open the runtime properties\ncat openmrs-runtime.properties\n\n# Exit the openMRS pod\nExit","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Keep a note of the above DB details and maintain them securely until the setup is completed successfully","type":"text"}]}]},{"type":"paragraph","content":[{"text":"5. Copy the files to local machine","type":"text"}]},{"type":"codeBlock","content":[{"text":"# Copy the checksums zip to the local\nkubectl cp performance/openmrs-:/openmrs/data/configuration_checksums.zip configuration_checksums.zip\n\n# Copy the sql dump to the local\nkubectl cp performance/openmrs-:/openmrs/data/omrsdb.sql omrsdb.sql","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Build the DB in Docker","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"We used mysql 5.7 for our setup, if you use mysql 5.6 kindly change it wherever applicable.","type":"text"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"~/bahmni-scripts/demo/db-backups/1.0.0-lite/mysql5.7/resources","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"paragraph","content":[{"text":" 2. Delete the files present in this directory","type":"text"}]},{"type":"paragraph","content":[{"text":" 3. Copy and paste the files exported from the pod i.e ","type":"text"},{"text":"configuration_checksums.zip","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"omrsdb.sql","type":"text","marks":[{"type":"code"}]},{"text":" to this directory","type":"text"}]},{"type":"paragraph","content":[{"text":"4. Navigate back to the mysql5.7 directory and replace the Dockerfile contents with the following code:","type":"text"}]},{"type":"paragraph","content":[{"text":"Apple M1 Chip (Mac)","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"ARG arch\nFROM --platform=linux/amd64 mysql:5.7\n\n#Install the required tools\nRUN yum update -y && \\\n yum install -y \\\n unzip\n\n#Set the mysql root password\nENV MYSQL_ROOT_PASSWORD=\n\n#Copy configuration_checksums & DB Backup\nCOPY demo/db-backups/1.0.0-lite/mysql5.7/resources/*.zip .\nCOPY demo/db-backups/1.0.0-lite/mysql5.7/resources/*.sql /docker-entrypoint-initdb.d/omrs_db_backup.sql\n\nRUN unzip configuration_checksums.zip && \\\n rm configuration_checksums.zip","type":"text"}]},{"type":"paragraph","content":[{"text":"Others (Linux)","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"FROM mysql:5.7\n\n#Install the required tools\nRUN yum update -y && \\\n yum install -y \\\n unzip\n\n#Set the mysql root password\nENV MYSQL_ROOT_PASSWORD=\n\n#Copy configuration_checksums & DB Backup\nCOPY demo/db-backups/1.0.0-lite/mysql5.7/resources/*.zip .\nCOPY demo/db-backups/1.0.0-lite/mysql5.7/resources/*.sql /docker-entrypoint-initdb.d/omrs_db_backup.sql\n\nRUN unzip configuration_checksums.zip && \\\n rm configuration_checksums.zip","type":"text"}]},{"type":"paragraph","content":[{"text":"5. Navigate to bahmni-scripts root directory and execute the following docker command (note the TAGNAME should be set to some specific value. e.g my-build-1):","type":"text"}]},{"type":"codeBlock","content":[{"text":"docker build --no-cache -t bahmni/openmrs-db: -f demo/db-backups/1.0.0-lite/mysql5.7/Dockerfile .","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Config the environment and docker compose ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to the ","type":"text"},{"text":"bahmni-docker/bahmni-lite","type":"text","marks":[{"type":"code"}]},{"text":" or ","type":"text"},{"text":"bahmni-india-package","type":"text","marks":[{"type":"code"}]},{"text":" directory where the ","type":"text"},{"text":"docker- compose.yml","type":"text","marks":[{"type":"code"}]},{"text":" is present","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"If using Apple M1 chip, add ","type":"text"},{"text":"platform: linux/amd64","type":"text","marks":[{"type":"code"}]},{"text":" to each service present under the docker compose file.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"2. Add the openMRS DB details captured earlier in ","type":"text"},{"text":"DB backup extraction","type":"text","marks":[{"type":"link","attrs":{"href":"#dblink"}}]},{"text":" to the .env file and save it. Ensure the ","type":"text"},{"text":"OPENMRS_DB_IMAGE_NAME","type":"text","marks":[{"type":"code"}]},{"text":" is pointing to the newly created docker image (as generated in the previous step).","type":"text"}]},{"type":"codeBlock","content":[{"text":"# OpenMRS Environment Variables\nOPENMRS_IMAGE_TAG=latest\nOPENMRS_DB_IMAGE_NAME=bahmni/openmrs-db:\nOPENMRS_DB_NAME=\nOPENMRS_DB_HOST=openmrsdb\nOPENMRS_DB_USERNAME=\nOPENMRS_DB_PASSWORD=\nOPENMRS_DB_CREATE_TABLES='false'\nOPENMRS_DB_AUTO_UPDATE='true'\nOPENMRS_MODULE_WEB_ADMIN='true'\nMYSQL_ROOT_USERNAME=root\n# OMRS_DEV_DEBUG_PORT=\nOMRS_JAVA_SERVER_OPTS=''\nOMRS_JAVA_MEMORY_OPTS=''\nOPENMRS_UPLOAD_FILES_PATH=./openmrs-uploads\nBAHMNI_OPENMRS_MODULES_PATH=\nMYSQL_ROOT_PASSWORD=\nOPENMRS_DB_TYPE=mysql\nOPENMRS_DOCKER_ENV='true'","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Invoke Bahmni Lite","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Bring up Bahmni through Docker compose","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"docker-compose up -d --build","type":"text"}]},{"type":"paragraph","content":[{"text":"2. Wait for openmrs to load with all the required indexes","type":"text"}]},{"type":"paragraph","content":[{"text":"3. Enter “","type":"text"},{"text":"http://localhost/openmrs","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"http://localhost/openmrs"}}]},{"text":"” in browser and verify openMRS is up","type":"text"}]},{"type":"paragraph","content":[{"text":"4. Navigate to “","type":"text"},{"text":"http://localhost/","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"http://localhost/"}}]},{"text":"” and start using Bahmni (this should now run with the new DB)","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported