Difference between revisions of "OpenEMR Backup Tools"
From OpenEMR Project Wiki
Bradymiller (talk | contribs) (Created page with '== Overview == I am going to get on a little small soapbox for all the newbies using OpenEMR. Electronic Medical Records are your livelihood and exist to protect the health of…') |
Bradymiller (talk | contribs) (→Linux) |
||
(31 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
== Overview == | == Overview == | ||
Words of advice on backing up: | |||
* The first most basic requirement of any database is a regular, frequent, comprehensive backup system. | |||
* Losing data should terrify you. | |||
* Hardware fails. Lightning strikes happen. | |||
* A good backup strategy is drudgery but nothing will give such a warm, glowing, fuzzy, feeling like successfully recovering your system from a recent backup after a lightning strike that burns out a critical component on your server. | |||
* Backup your databases on a regular basis (daily is best). Make frequent secure backups of the MySQL data and the data in the openemr web directory. | |||
* If you have the resources it is best to back up to an off site facility. This can be done electronically over a secure internet connection (VPN) or you can burn CDs / DVDs and carry them off site. | |||
Losing | * Always backup before starting an upgrade. | ||
Hardware fails. Lightning strikes happen. | |||
Always backup before starting an upgrade. | |||
== Linux == | == Linux == | ||
* [http://www.bradymd.com/appliance/ | * [http://www.bradymd.com/appliance/manual9/#__RefHeading__5628_695817034 Ubuntu Backup] : This method/script will backup the complete MySQL database and the complete OpenEMR web directory. It will automatically backup encrypted data to a local directory and burn the encrypted data to a multisession DVD(so, you can just leave the same DVD in the drive). Here is a link to the raw script, if wanted: [[Media:Fullbackup4_sh.zip|fullbackup4_sh.zip]] | ||
* [http://www. | * [[Backing Up Using the Built In Tools]] : OpenEMR has a built in 'backup' facility. this page describes how to use it, and how to manually perform the same task. | ||
* [http://www.openhealthit.info/2010/06/openemr-dump-database/ Dump Database - Hourly ] : This procedure creates a database dump every hour and cleans out old backups once a day. | |||
* [[Automated Backups to an Alternate Server]] : Rod's preferred method (documentation sponsored by IPPF). | |||
== Windows == | == Windows == | ||
*[[Windows OpenEMR Backup and Recovery| Windows Backup/Recovery]] a Downloadable HowTo using Windows Batch Routine Files (PDF Copy Enclosed) written by [http://www.holzerent.com Joe Holzer]. | |||
*[[Windows OpenEMR Restore using emr_backup.tar|Windows Restore from OpenEMR native backup file]] - Restore from your previously backed-up file (emr_backup.tar) | |||
*[[Windows OpenEMR Backup and Recovery over Amazon Web Services]] A way to automate the encrypted backup of my windows server to Amazon web services (S3 cloud). | |||
*[[Windows Backup And Restore Made Easy]] A third way to backup. | |||
== OS-X == | |||
[[Category:Backup]][[Category:Configuration Guide]] |
Latest revision as of 22:00, 21 May 2016
Overview
Words of advice on backing up:
- The first most basic requirement of any database is a regular, frequent, comprehensive backup system.
- Losing data should terrify you.
- Hardware fails. Lightning strikes happen.
- A good backup strategy is drudgery but nothing will give such a warm, glowing, fuzzy, feeling like successfully recovering your system from a recent backup after a lightning strike that burns out a critical component on your server.
- Backup your databases on a regular basis (daily is best). Make frequent secure backups of the MySQL data and the data in the openemr web directory.
- If you have the resources it is best to back up to an off site facility. This can be done electronically over a secure internet connection (VPN) or you can burn CDs / DVDs and carry them off site.
- Always backup before starting an upgrade.
Linux
- Ubuntu Backup : This method/script will backup the complete MySQL database and the complete OpenEMR web directory. It will automatically backup encrypted data to a local directory and burn the encrypted data to a multisession DVD(so, you can just leave the same DVD in the drive). Here is a link to the raw script, if wanted: fullbackup4_sh.zip
- Backing Up Using the Built In Tools : OpenEMR has a built in 'backup' facility. this page describes how to use it, and how to manually perform the same task.
- Dump Database - Hourly : This procedure creates a database dump every hour and cleans out old backups once a day.
- Automated Backups to an Alternate Server : Rod's preferred method (documentation sponsored by IPPF).
Windows
- Windows Backup/Recovery a Downloadable HowTo using Windows Batch Routine Files (PDF Copy Enclosed) written by Joe Holzer.
- Windows Restore from OpenEMR native backup file - Restore from your previously backed-up file (emr_backup.tar)
- Windows OpenEMR Backup and Recovery over Amazon Web Services A way to automate the encrypted backup of my windows server to Amazon web services (S3 cloud).
- Windows Backup And Restore Made Easy A third way to backup.