Do you use or administer OpenEMR? Take the General Satisfaction Survey to help improve the product

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.

@liwenz The openemr.tar.gz file is the directory file which was compressed
You can extract the file to your apache directory to retrieve your OpenEMR directory

The OpenEMR also has a restore script to restore both the database and directory from emr_backup.tar file

You can follow the steps in the following link to restore it completely


@liwenz Yet another option not mentioned so far is the patient data generator, PrintaPatient.
An older version is found here,
called ‘data generator’ (first item on page)
described as:
"Slick data generator for random patients, demographics, insurance companies, and assigning insurance companies to patients created by Art Eaton to run on Windows. "
It runs on linux under wine just fine.
A newer version is out there called ‘’. It outputs more different data and is compatible with newer systems but I can’t find where to get it; the old forum I got it from is dead and gone.