Read about OpenEMR's Response to the COVID-19 Pandemic at

Is there demo database for openemr study?

I have installed openemr server at
I hope to have some demo data to study and restore in some demo database.
Are there several role in openemr,admin, doctor,patient, etc. Is there proper manual for each role?Where?
OpenEMR Version
I’m using OpenEMR version is 5.0.2

I’m using: Google Chrome 85.0.4183.83

Operating System
I’m using: ubuntu 18.04 for openemr

Did you check the logs? Was there anything pertinent in them? Paste them here (surround with three backticks (```) for readability
new learner.

Go to this page and on the page you will find a link to the current and past manuals.

You can download the data of demo database from

The following are steps to be followed to download the data from OpenEMR

  • OpenEMR has a built-in backup option in the Administration tab.
  • Go to Administration-> Backup then click on Create a Backup.
  • Create a backup option will dump the database and web directory into a tar file. Rename the file with date so that it could be useful for reference. (Eg: emr_backup.tar )
  • The .tar file contains all of the data from the database as well as any scanned documents the user has uploaded into OpenEMR.
  • It will retrieve the database and directory in a tar file
    Inside the tar file you can see the sql file

You can import this file using the command mysql -uroot -p “your database name” < openemr.sql


Thanks for your reply.
I have visited the link for many times.
There are only lots of links again. Or some video tutorial.
Are there only 4.0 version manual. In the video, there is not any word document.

hi @liwenz, try spinning up the dev docker and see step 10 to easily load some demo data (thank you

Thanks for your help.
The link should be
tar -xvf emr_backup.tar
I got
Then gunzip openemr.sql.gz
I got openemr.sql
Then: mysql -uroot -p oepnemr < openemr.sql
finally, I got the database, I login as admin and pass as password.

Thanks for your help. Now I get the database.
I have another question, how to restore the directory. When I bacckup, I also get the openemr.tar.gz.