I created 3 docker containers… Mysql, Openemr and Phpmyadmin.
I assume I can backup phpmyadmin once.
I assume I can backup OpenEmr container once a Month.
Are people backing up the Database on mysql or the entire container? What about the attached volume?
If you backup just the database can this be moved easily to another machine/environment incase of hardware failure?
PHPMyAdmin, there’s really not much there to back up, unless you’re just saying to keep a backup of the container that’s working, in case there’s a failure or the container is accidentally changed? Unless you have a really exotic setup with a heavily customized PMA, that’s pretty simple to reconstitute.
Everything else, should be backed up daily at the very least, remember that every time you store a patient file, like a document, scanned insurance card, ID card, lab result document, etc, that becomes a part of the EMR data.
Likewise with the database, every time something in the patient record is altered and saved, that’s writing updated/new records to the data tables.
Backing up MariaDB or Mysql at the database level is probably going to give you better results and be more efficient than just storing copies of the container. In addition to which if it’s all just running on a single Windows host with no redundancy, you might run into data integrity concerns making copies of a container with a running database. If you do choose to do the backup at the container rather than at the database level, at the very least make sure that the service is stopped so you get a clean backup. I’ve seen some horror stories from people who tried to make backups of databases without using the proper tools/methods.
Whats the best tool to backup mysql and openemr files?
Thanks for the advise
for Mysql , mysqldump. Or mariadb-dump if you switched to Maria for your database engine.
For the rest of the application/data, it depends on what your backup target is.
Rsync and borg are both very useful, but maybe not so much on Windows.
Backup MySQL Database
Open PowerShell or CMD:
Run this command Replace your_mysql_root_password with your actual root password.
Backup sites/ Directory (Contains Patient Docs, Settings, etc.):
a. Create a Batch File (e.g., openemr_docker_backup.bat)
Replace YOUR_ROOT_PASSWORD with your MySQL password.
b. Add to Windows Task Scheduler
Open Task Scheduler
Create a new task
Trigger: Daily at a chosen time
Action: Start a program → point to your .bat file
Thank you… Didn’t think of the stuff on Openemr webserver… Thanks for the example scripts
Your’s welcome. We are one of the OpenEMR based sollution provider.
Integrated voice recording feature, check this new feature of Voice recording. Just one time charge to implement. Schedule to add this feature on your EMR
