Database storage

luke731 wrote on Monday, August 29, 2005:

Where exactly does OpenEMR store it’s database on the hard drive?  We back up certain files every night and I want to make sure the database is included, as that would be a terrible thing to lose.

Thanks, Chris

sunsetsystems wrote on Monday, August 29, 2005:

The physical database location would depend on your MySQL installation.  However you don’t need to know that in order to back it up.  Do “man mysqldump” for information about making backups.

Likewise if you use SQL-Ledger with it, see also "man pg_dump".

For backing up to CD-ROM, see also mkisofs and cdrecord.

– Rod (http://www.sunsetsystems.com/)

slim180 wrote on Wednesday, September 23, 2009:

I believe it is mostly stored in MySQL (except the SQL Ledger). 

Because the database can change, you never want to copy database files while the server is running.  Instead, use the database backup utility.  For MySQL it is called: mysqldump