I've set up DHIS2 Live on my computer. I would like to import the sample data that is supplied along with DHIS2 Live, it's a file called "default.sql".
How do I go about importing sql data?
thanks...
2 Answers
Assuming this is Windows only. Its a 4 step process:
- Download the demo database from the dhis download site. It's about 188 MB.
- Unzip it to get a 2.4GB sql file!
Restore the demo database using psql. You may need to create a database and its user in pgAdmin, or CLI. use google here.
- Find psql somewhere in
C:\...\PostgreSQL\bin. You can use Windows search. - Open CMD here by holding shift then right-click on a whitespace.
- Run
psql -d dbname -U username -f demo.sql
- Find psql somewhere in
After the database is setup. Configure the
hibernate.propertiesor create a newdhis.conffile under the/conffolder then paste the orginal dhis.conf contents as in the implementation guide, ensure your password and username is as in step 3.
You may also refer to this article from the dhis-users group on launchpad.
-
I followed all your steeps but during database demo.sql import, it comes with several msgs like "invalid command \N". It implies that it does not import complete database demo.sql file. So import process does not complete successfully.– user70181Sep 18, 2016 at 4:52
Please check your database server version with the version of dump you are going to import. Your dumped database server version mentioned above of the sample database dumped file
Example:
- PostgreSQL database dump
- Dumped from database version 10.4
- Dumped by pg_dump version 10.4
I have found the similar issues with Postgres 11 later downgrade of my database server to 10 worked fine for me.
