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.
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.
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