Before you run the DIGIT HCM product, you need to set up the basic system data such as boundaries of the geography and the master data. In this document, we will load the base data for the server.
Download Database Dump File
Download the seed_data_dump.sql file into your local system and save it in a folder/directory.
Load the Backup File into the Database
To load the file to the database:
Get the database pod name by executing the following command and copy the NAME from the output. Refer to the screenshot below:
kubectl get pods -n playground
We also need db_name, and db_username. We configured these values earlier in the forked repository infra-as-code/terraform/sample-aws/input.yaml file.
Navigate to infra-as-code/terraform/sample-aws.
Open input.yamland note down db_username, db_name, which configured earlier.
Get {DB_HOST} the value by executing the command below, and find and copy the "db-host" value. Refer to the screenshot below for select and copy of "db-host". This will be used in the next commands.
kubectl describe cm -n egov egov-config
Load Data into the Database
Now we have all the data required to run the command below which will load the data into the database.
Go to the folder/directory where the dump file was downloaded and open the terminal in that folder or use the 'cd' command to change to that directory:
Replace {PLAYGROUND_POD_NAME} , {DATABASE_HOST}, {DATABASE_USERNAME}, {DB_NAME} in the command given below and run it:
